Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

no other information needed Excel Activity: Forecasting Financial Statements Morrissey Technologies Inc.'s 2021 financial statements are shown here. Morrissey Technologies Inc.: Balance Sheet as of

image text in transcribedimage text in transcribedimage text in transcribed
no other information needed
Excel Activity: Forecasting Financial Statements Morrissey Technologies Inc.'s 2021 financial statements are shown here. Morrissey Technologies Inc.: Balance Sheet as of December 31, 2021 Morrissey Technologies Inc.: Income Statement for December 31, 2021 Sales Operating costs including depreciation EBIT Interest EBT Taxes (25%) Net income Per share data: Common stock price Earnings per share (EPS) Dividends per share (DPS) $40.00 $2.25 $1.35 Suppose that in 2022, sales increase by 12% over 2021 sales. The firm currently has 100,000 shares outstanding. It expects to maintain its 2021 dividend payout ratio and believes that its assets should grow at the same rate as sales. The firm has no excess capacity. However, the firm would like to reduce its operating costs/sales ratio to 85.5% and increase its total liabilities-to-assets ratio to 35%. (It believes its liabilities-to-assets ratio currently is too low relative to the industry average.) The firm will raise 30% of the 2022 forecasted interest-bearing debt as notes payable, and it will issue long-term bonds for the remainder. The firm forecasts that its before-tax cost of debt (which includes both short- and long-term debt) is 12.5%. Assume that any common stock issuances or repurchases can be made at the firm's current stock price of $40. a. Construct the forecasted financial statements assuming that these changes are made. What are the firm's forecasted notes payable and long-term debt balances? What is the forecasted addition to retained earnings? Round your answers to the nearest cent. Morrissey Technologies Inc.: Pro Forma Income Statement for December 31, 2022 Sales Operating costs including depreciation Earnings before interest and taxes (EBIT) Interest Earnings before taxes (EBT) Taxes (25\%) Net income (NI) Dividends Addition to retained earnings $ $ Morrissey Technologies Inc.: Pro Forma Balance Sheet as of December 31, 2022 Assets Cash Receivables Inventories Total current assets Fixed assets Total assets Liabilities and Equity Accounts payable Accrued liabilities Notes payable Total current liabilities Long-term debt Total liabilities Common stock Retained earnings Total common equity Total liabilities and equity $ $ $ $ $ $ $ $ $ b. If the profit margin remains at 7.50% and the dividend payout ratio remains at 60%, at what growth rate in sales will the additional financing requirements be exactly zero? In other words, what is the firm's sustainable growth rate? (Hint: Set AFN equal to zero and solve for g.) Round your answer to two decimal places. %

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions

Question

Explain the factors influencing wage and salary administration.

Answered: 1 week ago

Question

Examine various types of executive compensation plans.

Answered: 1 week ago

Question

1. What is the meaning and definition of banks ?

Answered: 1 week ago

Question

Consistently develop management talent.

Answered: 1 week ago

Question

Create a refreshed and common vision and values across Europe.

Answered: 1 week ago

Question

Provide the best employee relations environment.

Answered: 1 week ago