Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The company selected is Uber. I have attached the income statement and balance sheet template. The years are 2019, 2020 and 2021. Please help. -

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

The company selected is Uber. I have attached the income statement and balance sheet template. The years are 2019, 2020 and 2021.

Please help.

- Part II: Submit the Financial Statements: Income Sheet and Balance Sheet. - Part II: Submit an overview of the analysis (50-100 words) for both the projected financial statement and balance sheet. Percentages in the Projected Income Statement will be multiplied by the most recent year. For example, if you enter in 10\% for projected revenues in projected year 2 , the Template v ill use the equation [1.10s projected year 1 rovenues] = projected year 2 revenues. For line items in the projected income statement requesting dollar amounts, please read the note below for the balance sheet. The saloulations mork the same maulas described there torical Percent Notes Below. Enter your data in the EXACCT same mat as the Notes describe. torical Note: Difference the two most recent years of data. Enter rent increases you eupect based on your recommendations. Do not idly use the historical number provided. Enter as percent. torical Note: Percent of Sales in the most recent year. Use a similar reent across all three projected years unless you believe COGS to espercent will change drasticallu. Enter as percent. torical Note: Percent of Sales in the most recent year. Use a similar reent across all three projected years unless you believe Dperating zenses to sales percent will change drastically. Enter as percent. rorcalvote: Domar amount of interest paldin the moss recentyear. ter in the NEW' NET dollar amounts of interest you will forecasted for chyear. If your most recent interest payment was $500 and you plan a $20 net increase in interest for projected year 1 , simply enter in $20 year one. If financing through debt, the number is more likely to rease more than if financing through equity. Enter as dollar amount. If anticipate less interest expense than the year before, enter as a torical Note: Tau Rate in most recent year. You can likely use the same irate throughout unless you expect a large increaseldecrease in Ienues and subsequentlyEBT. Enter as percent. he propectedialance Sieet is designed on you to enter in he NET ADDITIDHAL DDLLAR WALUES (for PPE, Goodwill, and Intangibles]. The Template will add these values to the existing numbers. For Example, if you are adding $1,000 in inventory in projected year 1, [but you estimate your firm used $800 of its existing inventory from the prior year] just enter in $200 [ $1,000$800] in the corresponding bok and Historical Note: If your cash number appears too high or low, consult Chapter 8 of the testbook for more information. Also, compare your ojected ratios to historical ratios. You may need to make adjustments to your recommendations andior your projected statements. It is rare for any firm to have acoeptal projected statements after the first attempt. Historical Wote: Percent of revenues in the most recent year. Lse a similar percent across all three projected years unless you believe the current assets to revenues percent will change drastioally. Enter as peroent the net new (not oumulative) dollar amounts for each item for each forecasted year [Exoept for the Cash and Equivalents line]. If you are purchasing $200 of Property. Plant \& Equipment in Projected Year 1 . simply enter $200 into the first projected year. If you plan to also reduce existing PP8E by $300, then you would enter in a negative $100 into Projected Year 1[ assuming you still plan to purchase the other $200 ). istorical Note: Peroent of revenues in the most recent year. Use a similar eroent across all three projected years unless you believe the other long erm asets to revenues percent will change drastically. Enter as percent istorical Note: Peroent of rewenues in the most reoent year. Use a similar percent across all three projected years unless you believe the current liabilities to revenues percent will change drastically. Enter as percent. listorioal Note: The walues are for the most recent year reported. Enter in the net new (not oumulative) dollar amounts for each item for each reoasted year. For example, if you do not plan to take on any additional ing term debt in Projeoted Year 1, but do plan to pay off $1,000 in debt in Projected Year 1, enter in ($1,000) in Projected Year 1 long term debt columa. armote: Peroent of revenues in the most recent year. use a similar tt across all three projected years unless you believe the other long n liabilities to revenues percent will change drastically. Enter as :al Note: The values are for the most reoent year reported. Enter in hew [additional, not cumulative] Dollar amounts for each ltem for forecasted year. If you change Treasury Stook, you may need to ake an adjustment to Paid in Capital. Enter Treasury Stook as a ative number. Read over Chapter 8 of the David, David and David textbook. d. The new additional (not cumulative) Retained Earnings are ited automatioally. oreoasted year. If none, enter 0 . This line is not cumulative, it does It the value to any existing value for dividends. For example, if the aid $1,000 in dividends and you wish to stop dividend payments. h in projected year 1 bou. If you wish to increase dividends by 10\%. ter $1,100 into projected year 1 bou. Check on your own to see - Part II: Submit the Financial Statements: Income Sheet and Balance Sheet. - Part II: Submit an overview of the analysis (50-100 words) for both the projected financial statement and balance sheet. Percentages in the Projected Income Statement will be multiplied by the most recent year. For example, if you enter in 10\% for projected revenues in projected year 2 , the Template v ill use the equation [1.10s projected year 1 rovenues] = projected year 2 revenues. For line items in the projected income statement requesting dollar amounts, please read the note below for the balance sheet. The saloulations mork the same maulas described there torical Percent Notes Below. Enter your data in the EXACCT same mat as the Notes describe. torical Note: Difference the two most recent years of data. Enter rent increases you eupect based on your recommendations. Do not idly use the historical number provided. Enter as percent. torical Note: Percent of Sales in the most recent year. Use a similar reent across all three projected years unless you believe COGS to espercent will change drasticallu. Enter as percent. torical Note: Percent of Sales in the most recent year. Use a similar reent across all three projected years unless you believe Dperating zenses to sales percent will change drastically. Enter as percent. rorcalvote: Domar amount of interest paldin the moss recentyear. ter in the NEW' NET dollar amounts of interest you will forecasted for chyear. If your most recent interest payment was $500 and you plan a $20 net increase in interest for projected year 1 , simply enter in $20 year one. If financing through debt, the number is more likely to rease more than if financing through equity. Enter as dollar amount. If anticipate less interest expense than the year before, enter as a torical Note: Tau Rate in most recent year. You can likely use the same irate throughout unless you expect a large increaseldecrease in Ienues and subsequentlyEBT. Enter as percent. he propectedialance Sieet is designed on you to enter in he NET ADDITIDHAL DDLLAR WALUES (for PPE, Goodwill, and Intangibles]. The Template will add these values to the existing numbers. For Example, if you are adding $1,000 in inventory in projected year 1, [but you estimate your firm used $800 of its existing inventory from the prior year] just enter in $200 [ $1,000$800] in the corresponding bok and Historical Note: If your cash number appears too high or low, consult Chapter 8 of the testbook for more information. Also, compare your ojected ratios to historical ratios. You may need to make adjustments to your recommendations andior your projected statements. It is rare for any firm to have acoeptal projected statements after the first attempt. Historical Wote: Percent of revenues in the most recent year. Lse a similar percent across all three projected years unless you believe the current assets to revenues percent will change drastioally. Enter as peroent the net new (not oumulative) dollar amounts for each item for each forecasted year [Exoept for the Cash and Equivalents line]. If you are purchasing $200 of Property. Plant \& Equipment in Projected Year 1 . simply enter $200 into the first projected year. If you plan to also reduce existing PP8E by $300, then you would enter in a negative $100 into Projected Year 1[ assuming you still plan to purchase the other $200 ). istorical Note: Peroent of revenues in the most recent year. Use a similar eroent across all three projected years unless you believe the other long erm asets to revenues percent will change drastically. Enter as percent istorical Note: Peroent of rewenues in the most reoent year. Use a similar percent across all three projected years unless you believe the current liabilities to revenues percent will change drastically. Enter as percent. listorioal Note: The walues are for the most recent year reported. Enter in the net new (not oumulative) dollar amounts for each item for each reoasted year. For example, if you do not plan to take on any additional ing term debt in Projeoted Year 1, but do plan to pay off $1,000 in debt in Projected Year 1, enter in ($1,000) in Projected Year 1 long term debt columa. armote: Peroent of revenues in the most recent year. use a similar tt across all three projected years unless you believe the other long n liabilities to revenues percent will change drastically. Enter as :al Note: The values are for the most reoent year reported. Enter in hew [additional, not cumulative] Dollar amounts for each ltem for forecasted year. If you change Treasury Stook, you may need to ake an adjustment to Paid in Capital. Enter Treasury Stook as a ative number. Read over Chapter 8 of the David, David and David textbook. d. The new additional (not cumulative) Retained Earnings are ited automatioally. oreoasted year. If none, enter 0 . This line is not cumulative, it does It the value to any existing value for dividends. For example, if the aid $1,000 in dividends and you wish to stop dividend payments. h in projected year 1 bou. If you wish to increase dividends by 10\%. ter $1,100 into projected year 1 bou. Check on your own to see

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

Nmap Network Exploration And Security Auditing Cookbook

Authors: Paulino Calderon

2nd Revised Edition

1786467453, 978-1786467454

More Books

Students also viewed these Accounting questions

Question

f. Did they change their names? For what reasons?

Answered: 1 week ago