Question: a. Use the Dynamic Mattress model and the live spreadsheets on the books Web site at www.mhhe.com/bma to produce pro forma income statements, balance sheets,

a. Use the Dynamic Mattress model and the “live” spreadsheets on the book’s Web site at www.mhhe.com/bma to produce pro forma income statements, balance sheets, and statements of cash flows for 2010 and 2011. Assume business as usual except that now sales and costs are planned to expand by 30% per year, as are fixed assets and net working capital. The interest rate is forecasted to remain at 10% and stock issues are ruled out. Dynamic also sticks to its 60% dividend payout ratio.

b. What are the firm’s debt ratio and interest coverage under this plan?

c. Can the company continue to finance expansion by borrowing?

Step by Step Solution

★★★★★

3.41 Rating (189 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

a Pro Forma Income Statement 2009 2010 2011 Revenues 30 growth 22000 28600 37180 Costs 30 growth 205... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Document Format (1 attachment)

214-B-C-F-F-P-M (606).docx

120 KBs Word File

Students Have Also Explored These Related Corporate Finance Questions!

a. Use the Dynamic Mattress model (Tables 29.8 - 29.10) and the spreadsheets on the book's website at www.mhhe.com/bma to produce pro forma income statements, balance sheets, and statements of cash...

Use the following statement of cash flows for the Matlock Company to answer the required questions: Requirements 1. How did Matlock Company use the majority of its cash during 2010? 2. What...

Use the following statement of cash flows for the SS&P Company to answer the required questions: Requirements 1. How did SS&P Company use the majority of its cash during 2011? 2. What information...

20. a. Use the Dynamic Mattress model ( Tables 29.8 29.10 ) and the live spreadsheets on the books Web site at www.mhhe.com/bma to produce pro forma income statements, balance sheets, and statements...

a. Use the Dynamic Mattress model ( Tables 29.8 29.10 ) and the live spreadsheets on the books Web site at www.mhhe.com/bma to produce pro forma income statements, balance sheets, and statements of...

Working on a final paper evaluating General Motors Co, corporate performance. Attached is the outline of the assignment along with GM financial annual statement. Evaluation of Corporate Performance...

1. Review the spreadsheet model, paying particular attention to (1) what assumptions are currently embedded in the model, (2) how the financial forecasts are developed, and (3) how financing...

I need homework help with Financial Analysis & Forecasting for a case. Pennsylvania Box Company. So far, I was able to complete Tables 1-3. I need assistance with the rest, table 4-6 and the analysis...

I need homework assistance with a financial analysis & forecasting case for the Pennsylvania Box Company. There are also analysis questions (1-12) that need to be answered as well. So far, I have...

18. Long-term planning models (S30.4) a. Use the Dynamic Mattress model in Table 30.8 and the spreadsheets to produce pro forma income statements, balance sheets, and statements of cash flows for...

The phase diagram of liquid 3 He 4 He mixtures in Figure shows that the solubility of 3 He in 4 He remains finite (about 6 pct) as 0. Similarly, the Pb-Sn phase diagram of Figure shows a finite...

Response, analyze how the use of technology has impacted organizational communication both positively and negatively. How has technology impacted the verbal and nonverbal cues used in interpreting...

You are considering to purchase a 1 2 year 7 % coupon rate bond ( it pays interest on semi - annual basis ) which has yield to maturity of 6 . 5 % . You expect the yield to maturity on these bonds to...

Using diagrams explain the differences between the effects of price and quantity as a result of non-tariff barriers on trade.

Some corporations have issued perpetual warrants. Warrants are call options issued by a firm, allowing the warrant-holder to buy the firms stock.. For now, just consider a perpetual call. (a) What...

Describe each of the following situations in the language of options: (a) Drilling rights to undeveloped heavy crude oil in Northern Alberta. Development and production of the oil is a negative-NPV...

After a good nights sleep, your boss, the CFO in Section 22.1, still doesnt understand. Try again. Explain why the Mark I microcomputer has a positive NPV even though DCF analyses of both the Mark I...

Suppose we have the following returns for large-company stocks and Treasury bills over a six year period: a. Calculate the arithmetic average returns for large-company stocks and T-bills over this...

if the population: interpret these results. 4. By using the same mean and standard deviations as in problem 3, change the sample size to 25 and construct a confidence interval around the mean using...

QUESTION 1 A firm should only pay cash dividends during the maturity phase. True False QUESTION 2 A stock dividend is a lower cost alternative to a cash dividend and can be considered at all but the...