Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

You were given SkyBlue's 2020 income statement (IS) and balance sheet (BS), along with forecasts of the revenue growth and tax rates You must forecast

You were given SkyBlue's 2020 income statement (IS) and balance sheet (BS), along with forecasts of the revenue growth and tax rates You must forecast the IS and BS for the next 3 years.

image text in transcribed

Actuall 2020 Projected 2021 2022 2023 Notes 3.3% 21% 3.4% 21% Income Statement Key Assumptions: Average growth rate: Tax Rate Net Sales - Cost of Goods Sold (COGS = Gross Profit - S.G & A Expenses = EBIT - Interest = EBT - Taxes = Net Income Balance Sheet Cash Notes and Acc. Rec. Inventory Prepaid Current Assets Other Total Assets 21% 4,233 2,700 1,533 1,199 334 77 257 54 203 3.5% 21% Use current statutory rate of 21% Increase using the average growth rate Use same percent of Net Sales as in 2018 Calculation Use same percent of Net Sales as in 2018 Calculation (Use for Free Cash Flow valuation!) Hold level Calculation Use implicit rate of 2018 Calculation Increase at average growth rate 230 664 715 65 1,674 102 1,776 Increase at average growth rate Plug to make balance sheet balance Increase at average growth rate Leave flat Increase at average growth rate Bank Loan Payables CPLTD Other Current Liabilities LTD Equity Total Liabilities & Equity 550 33 42 34 659 125 992 1,776 LTD of previous year minus CPLTD of current year Equity of previous year plus net income of current year Working Capital Exclude Bank Loan

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

Handbook Of Safeguarding Global Financial Stability Political Social Cultural And Economic Theories And Models

Authors: Gerard Caprio

1st Edition

0123978750, 0123978785, 9780123978752, 9780123978783

More Books

Students also viewed these Finance questions

Question

8. What is the difference between JIT and MRP?

Answered: 1 week ago