Finance

Have finance questions? Ask a financial expert online.

Ask an Expert,
Get an Answer ASAP!

I am preparing cash forecasts related to the acquisition of…

Customer Question
Hello, I am preparing cash...
Hello, I am preparing cash forecasts related to the acquisition of a small business in Maryland. Financing for this will primarily come from a bank loan.
I'm looking for a method by which I can demonstrate Sources and Uses of bank proceeds and the impact those line items have on my Income Statement and/or Balance Sheet.
By what method can I tie together the cash forecasts and Sources and Uses whereby the bank can easily detect the Debt Coverage Ratio and the impact the infusion will have on the cash flow?
Thank you.
Submitted: 2 years ago.Category: Finance
Show More
Show Less
Ask Your Own Finance Question
Answered in 3 days by:
3/18/2016
Financial Professional: BK-CPA, Certified Public Accountant (CPA) replied 2 years ago
BK-CPA
BK-CPA, Certified Public Accountant (CPA)
Category: Finance
Satisfied Customers: 933
Experience: Owner of a CPA firm
Verified

Hello and thank you for your question.

The ratios will generally come from your forecasted financial statements. You can prepare multiple forecasts, each relecting a different scenario.

To do this, set up your base case forecast and then alter it according to whatever assumptions you wish to make. I usually will use Excel to produce forecasted financial statements.

A bank probably doesn't want you to give multiple forecasts when considering your loan request. It may not mind a range for things that are variable in nature, like forecasted sales amounts. Frankly, the bank wants you to have a concrete business plan and know what you're doing with the money before they give it to you. If you have multiple options to consider then you should do so on your own time, choose the best one, and give the bank a forecasted set of financial statements showing that course of action.

If you don't know how to prepare financial statements, I'm guessing you'll need help. Let me know if that is the case and maybe I can help you compile a set of financials.

Ask Your Own Finance Question
Was this answer helpful?

How JustAnswer works

step-image
Describe your issueThe assistant will guide you
step-image
Chat 1:1 with a financial professionalLicensed Experts are available 24/7
step-image
100% satisfaction guaranteeGet all the answers you need
Ask BK-CPA Your Own Question
BK-CPA
BK-CPA
BK-CPA, Certified Public Accountant (CPA)
Category: Finance
Satisfied Customers: 933
933 Satisfied Customers
Experience: Owner of a CPA firm

BK-CPA is online now

A new question is answered every 9 seconds

How JustAnswer works:

  • Ask an ExpertExperts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional AnswerVia email, text message, or notification as you wait on our site. Ask follow up questions if you need to.
  • 100% Satisfaction GuaranteeRate the answer you receive.

JustAnswer in the News:

Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.
JustAnswer.com...has seen a spike since October in legal questions from readers about layoffs, unemployment and severance.
Web sites like justanswer.com/legal
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.

What Customers are Saying:

I really was impressed with the prompt response. Your expert was not only a tax expert, but a people expert!!! Her genuine and caring attitude came across in her response...

T.G.WMatteson, IL

I WON!!! I just wanted you to know that your original answer gave me the courage and confidence to go into yesterday's audit ready to fight.

BonnieChesnee, SC

Great service. Answered my complex tax question in detail and provided a lot of additional useful information for my specific situation.

JohnMinneapolis, MN

Excellent information, very quick reply. The experts really take the time to address your questions, it is well worth the fee, for the peace of mind they can provide you with.

OrvilleHesperia, California

Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help.

Mary C.Freshfield, Liverpool, UK

This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!!

AlexLos Angeles, CA

Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult.

GPHesperia, CA

< Previous | Next >

Meet the Experts:

Rakhi Vasavada

Rakhi Vasavada

Financial and Legal Consultant

2,609 satisfied customers

Graduated in law with Emphasis on Finance and have have been working in financial sector for over 12 Years

Megan C

Megan C

Certified Public Accountant (CPA)

2,222 satisfied customers

Licensed CPA, CFE, CMA, CGMA who teaches accounting courses at Master's Level

Manal Elkhoshkhany

Manal Elkhoshkhany

Tutor

1,933 satisfied customers

More than 5000 online tutoring sessions.

JKCPA

JKCPA

CPA

844 satisfied customers

Bachelors degree and CPA with Accounting experience.

Eric

Eric

Financial Manager

559 satisfied customers

Loan servicing, counseling and real estate expert. Foreclosure Expert and Financial Planner.

R. Klein, EA

R. Klein, EA

Accountant

480 satisfied customers

TurboTax Expert. QuickBooks Certified Pro Advisor

Dimitry K., Esq.

Dimitry K., Esq.

Attorney

332 satisfied customers

NASD Licensed Rep, 1997-2001, Business Attorney

< Previous | Next >

Related Finance Questions
Which of the following statements is correct? Assets on the
Which of the following statements is correct? Assets on the balance sheet include retained earnings. Retained earnings include contributed capital. The balance sheet equation states that assets equal … read more
FloridaCPA1
FloridaCPA1
Master\u0027s Degree
42 satisfied customers
for Businesstutor: Question 9 The term “additional
for Businesstutor: Question 9 The term “additional funds needed (AFN)” is generally defined as follows: Answer Funds that are obtained automatically from routine business transactions. Funds that a fi… read more
Manal Elkhoshkhany
Manal Elkhoshkhany
Tutor
1,933 satisfied customers
For BusinessTutor: Hi Can you please check what i wrote to
For BusinessTutor: Hi Can you please check what i wrote to see if it makes sense and it answers the question that is being asked? Forecasting Financial Statements please respond to the following: • An… read more
Manal Elkhoshkhany
Manal Elkhoshkhany
Tutor
1,933 satisfied customers
How is the statement of cash flows interrelated with the income
How is the statement of cash flows interrelated with the income statement and balance sheet? If you were a credit analyst, which financial ratios would be important to decision-making? Why? What ratio… read more
Rakhi Vasavada
Rakhi Vasavada
Financial and Legal Consultant
Bachelor's Degree
2,609 satisfied customers
need asap Who are the various stakeholders in a publicly
need asap Who are the various stakeholders in a publicly traded corporation, and why is communication of financial reports important to them? What is the impact on various stakeholders if financial re… read more
Stephen, MBA
Stephen, MBA
Master's Degree
166 satisfied customers
Financial analysts are mostly skeptical of he us of strategic
Financial analysts are mostly skeptical of he us of strategic considerations to justify pursuing a project. The observation is that some of the biggest investment disasters were undertaken base on a "… read more
Karla
Karla
Master's Degree
1 satisfied customers
1) Occurs when inaccurate information can falsely exist. A.
1) Occurs when inaccurate information can falsely exist. A. free-rider problem B. adverse selection C. moral hazard D. The Principle of Valuable Ideas 2) Which principle states that extraordinary retu… read more
Manal Elkhoshkhany
Manal Elkhoshkhany
Tutor
1,933 satisfied customers
In what ways do the elements of the four financial statements
In what ways do the elements of the four financial statements interact with one another? How might changing one of the financial statements affect the other financial statements? Why is it essential t… read more
Karla
Karla
Master's Degree
1 satisfied customers
questions 1-25 select the one best answer to each question. Use
questions 1-25: select the one best answer to each question. Use the following selected data and additional information to set up T accounts and create a statement of cash flows. Then answer questions… read more
Manal Elkhoshkhany
Manal Elkhoshkhany
Tutor
1,933 satisfied customers
4) Which account represents the cumulative earnings of the
4) Which account represents the cumulative earnings of the firm since its formation, minus dividends paid? A. Paid-in capital B. Accumulated depreciation C. Retained earnings D. Common stock 5) Which … read more
Manal Elkhoshkhany
Manal Elkhoshkhany
Tutor
1,933 satisfied customers
Leak Inc. forecasts the free cash flows shown below:
1. Leak Inc. forecasts the free cash flows (in millions) shown below. If the weighted average cost of capital is 11% and FCF is expected to grow at a rate of 5% after Year 2, what is the Year 0 value … read more
RD
RD
Self Employed
Master's Degree
1,164 satisfied customers
In what ways do the elements of the four financial
In what ways do the elements of the four financial statements interact with one another? How might changing one of the financial statements affect the other financial statements? Why is it essential t… read more
Haider
Haider
Doing CAT
226 satisfied customers
Financial Statements Analysis Using the financial statements
Financial Statements Analysis: Using the financial statements of Landry's Restaurants compute the following ratios for 2002 and 2003. I have to show how I arrived at the answers: a. Earnings per share… read more
Manal Elkhoshkhany
Manal Elkhoshkhany
Tutor
1,933 satisfied customers
1. Maximization of shareholders wealth is a concept in which a. Profits
1. Maximization of shareholders wealth is a concept in which a. Profits are maximizes on a quaterly basis b. Optimally increasing the long-term value of the firm is emphasized c. Virtually all earning… read more
Manal Elkhoshkhany
Manal Elkhoshkhany
Tutor
1,933 satisfied customers
How are the income statement and balance sheet related In
How are the income statement and balance sheet related? In what ways do the elements of the four financial statements interact with one another? How might changing one of the financial statements affe… read more
Mohammad Ali
Mohammad Ali
Accounts & Audit Officer
Master\u0027s Degree
278 satisfied customers
How are the income statement and balance sheet related In
How are the income statement and balance sheet related? In what ways do the elements of the four financial statements interact with one another? How might changing one of the financial statements affe… read more
Smartpants
Smartpants
Associate Degree
18 satisfied customers
FOR BUSINESS TUTOR Questions 1 25 Select the one best answer
FOR BUSINESS TUTOR Questions 1–25: Select the one best answer to each question. 151 1. Using risk assessment and control, which of the following risks would be most likely to require the creation of a… read more
Manal Elkhoshkhany
Manal Elkhoshkhany
Tutor
1,933 satisfied customers
What are the effects on the income statement, balance sheet,
What are the effects on the income statement, balance sheet, and cash flow statement for each of the following situations? Income statements: Will the net income be decreased, increased or will not be… read more
RD
RD
Self Employed
Master's Degree
1,164 satisfied customers
Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Show MoreShow Less

Ask Your Question

x