Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Can you please provide the excel formulas to answer the questions below? Here is the information from a previous question asked in Chegg, but I

image text in transcribed

Can you please provide the excel formulas to answer the questions below? Here is the information from a previous question asked in Chegg, but I am having trouble understanding how this information was found. Can you use data and excel equations to provide how the explanation to build come size income statements for 2016,2017 and 2018 was found?

image text in transcribed

Estimate the free cash flow of 2019 under the following assumptions. Assumptions: 1. Year 2019 sales projection: $31,556,000,000 2. All the other income statement accounts are assumed to hold a constant percentage as sales. The percentage is the average percentage of fiscal years 2016, 2017 and 2018. 3. Investment in net operating working capital and capital expenditure are assumed to stay perpetually as the average of year 2017 and 2018. Requirements: 1. Build common size income statements for year 2016, 2017 and 2018. 2. Prepare a pro forma income statement for year 2019.

Explanation: ==> 1. Build common size income statements for year 2016, 2017 and 2018: - Income Statement

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

Essentials Of Managerial Finance

Authors: Scott Besley, Eugene F. Brigham

12th Edition

0030258723, 9780030258725

More Books

Students also viewed these Finance questions

Question

How does selection differ from recruitment ?

Answered: 1 week ago