Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

[ The following information applies to the questions displayed below. ] Selected assumptions for 2 0 2 2 Sales growth rate 9 % Cost of

[The following information applies to the questions displayed below.]Selected assumptions for 2022Sales growth rate9%Cost of goods sold/Sales62%Dividends/Net income40%Income StatementBalance Sheet ActualForecast ActualForecast 2021202220212022Sales$ 1,000 Cash$ 100 Cost of goods sold600 Accounts receivable200 Operating expense200 Inventory500 Depreciation expense100 Total Current Assets800 EBIT100 Net PP&E1,000 Interest expense35 Total Assets1,800 Pre-tax income65 Tax26 Accounts payable300 Net Income$ 39 Bank loan100 Total Current Liabilities400 Long-Term Debt400 Shareholders' Equity1,000 Total Liabilities & Equity$ 1,800 Please refer to the spreadsheet above. Selected assumptions are given for preparing pro forma financial statements for 2022. Assume that gross property plant and equipment (PP&E) will grow at the sales growth rate in 2022. When the pro formas are completed, which of the following formulas would correctly give the forecast for net PP&E in cell G12?= F12* B2= F12*(1+B2) None of the options are correct. = F12 C11= F12 B11

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

Step: 3

blur-text-image

Ace Your Homework with AI

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

Get Started

Recommended Textbook for

Value Based Management With Corporate Social Responsibility

Authors: John D. Martin, J. William Petty, James S. Wallace

2nd Edition

0195340388, 978-0195340389

More Books

Students also viewed these Finance questions

Question

What are the best practices for managing a large software project?

Answered: 1 week ago

Question

How does clustering in unsupervised learning help in data analysis?

Answered: 1 week ago