Ask Question, Ask an Expert

+61-413 786 465

info@mywordsolution.com

Ask Corporate Finance Expert

Assignment - Pro forma financial statements, external capital needs and growth rates

Pro-forma financials using percentage of sales method;

1. Obtain financial statements for a company for the last three years. The company must meet the following criteria:

The company is not a financial company.

Each of current assets, current liabilities and long-term debt must be greater than zero for all three years.

The company must have paid a dividend in each of the last three years.

2. Determine the following from the company's financial statements for each of the last two or three years as indicated:

a. the total revenue, three years.

b. cost of revenue, two years.

c. total operating expenses, two years.

d. earnings before interest and taxes, two years

e. total interest paid, two years.

f. total income taxes paid, two years.

g. net income, two years.

h. total dividends paid, three years.

i. depreciation, two years.

j. net working capital, three years.

k. fixed assets, three years.

l. long term debt, three years.

m. total stockholders equity for the most recent year only.

3. Using the information from #2, compute the following for each of the last two years:

a. the growth rate in total revenue.

b. the ratio of cost of revenue plus total operating expenses minus depreciation to total revenue.

c. the ratio of depreciation to beginning of year fixed assets.

d. the ratio of net working capital to total revenue.

e. dividend payout ratio for the last two years.

f. the ratio of beginning of year fixed assets to total revenue.

g. the ratio of interest paid to beginning of year debt.

h. the ratio of total tax paid to earnings before tax.

4. Compute the average of each line item in #3. (That is, a. average annual revenue growth rate, b. average cash expense margin, c. average depreciation as a percent of fixed assets, etc.)

5. Using the company's most recent financial statements as the base and the values determined in #4, forecast operating cash flows for each of the next three years. Assume that revenue grows each year at the rate determined in #4a. This requires:

a. forecast sales based on prior year's sales

b. forecast cost of revenue and operating expenses based on same year sales forecast

c. forecast depreciation based on beginning of year fixed assets

d. EBIT calculated

e Interest based on beginning of year debt

f. earnings before tax calculated

g. tax calculated

h. net income calculated

i. operating cash flow calculated

6. Using the company's most recent financial statements as the base and the values determined in #4, forecast external funds needed by the company for investment in fixed assets, investment in net working capital and dividends for each of the next three years. (Assuming that all the external financing needs over the next three years are met by increasing/decreasing debt) This requires:

a. net working capital based on sales

b. change in net working capital calculated

c. fixed assets based on next year's forecast sales

d. change in fixed assets calculated

e. total dividends based on prior year's dividends

f. total external financing needed, calculated

g. long term debt calculated

7. Prepare simplified pro forma income statements and balance sheets for the next three years.

The income statement should include the following line items: revenue, cost of revenue and operating expenses, depreciation, EBIT, interest, earnings before taxes, tax, net income and operating cash flow.

The balance sheet should include the following line items: net working capital, net fixed assets, total assets, long-term debt, and equity.

Be sure to adjust income statement and balance sheet line items as appropriate to reflect the increase/decrease in long-term debt.

8. Using data from the most recent financial statement, calculate

a. the internal growth rate for the company.

b. the sustainable growth rate for the company.

9. Explain the meaning of the two growth rates from #8. Explain how each ratio relates to the external financing needs calculated in #6 for next year.

Corporate Finance, Finance

  • Category:- Corporate Finance
  • Reference No.:- M93127181
  • Price:- $25

Priced at Now at $25, Verified Solution

Have any Question? 


Related Questions in Corporate Finance

Descriptionstudents are required to study undertake

Description: Students are required to study, undertake research, analyse and conduct academic work within the areas of corporate finance. The assignment should examine the main issues, including underlying theories, impl ...

Questions -q1 global auto wants to choose the better of two

Questions - Q1. Global Auto wants to choose the better of two mutually exclusive projects for expanding the firm's production capacity. The relevant cash flows for the projects are shown in the following table. The firm' ...

Financial modelling assignment -1 today is 1 january 2018

Financial Modelling Assignment - 1. Today is 1 January 2018. Jackson who is aged 80 has a portfolio which consists of three different types of financial instruments (henceforth referred to as instrument A, instrument B a ...

Assignment -task this is an individual assignment in which

Assignment - Task: This is an individual assignment in which you are required to form a business and answer some accounting related questions. Assessment Criteria: This task will generally be assessed in terms of the fol ...

Assignment - preparing and analyzing a cash budgetselect

Assignment - Preparing and analyzing a cash budget Select assumptions for the following values that fall between the minimum and maximum indicated. Assumption Minimum Maximum a. Sales in month 1 $150,000 $250,000 b. Incr ...

Question - develop a forecast model for sales through

Question - Develop a forecast model for sales through operating income. Create the forecast in Excel. In a Word document, describe the set of assumptions (ratios) you used, and explain how you justify them. Attachment:- ...

Assignment - credit card liabilities and fraudwhen a credit

Assignment - Credit Card Liabilities and Fraud When a credit card is lost or stolen, it can be used until its owner reports it as missing. This loss of one's credit card can result in fraud and therefore, being aware of ...

Question - business performanceassess how business

Question - Business Performance Assess how Business Performance is measured, financially and non-financially, in your organization* and analyze its business performance. Organization is InterContinental Hotels Group (IHG ...

Assignment - pro forma financial statements external

Assignment - Pro forma financial statements, external capital needs and growth rates Pro-forma financials using percentage of sales method; 1. Obtain financial statements for a company for the last three years. The compa ...

Discussion question -what have you learned about financial

Discussion Question - What have you learned about financial derivatives? What concepts learned do you plan to utilize in your current job, career, and personal life?

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As