Answered step by step
Verified Expert Solution
Link Copied!

Question

...
1 Approved Answer

For the breakdown figure project those figures for the next three years ( end dates will be 9 / 3 0 / 2 4 -

For the breakdown figure project those figures for the next three years (end dates will be 9/30/24-25-26 so I will just refer to these as base year and Years 1-3 for purposes). But, you will need to provide your dates on your income statements. Keep all figures as they were stated in photo add a statement that "all figures are posted in thousands". Also, keep these as whole numbers, no "cents" as this will simplify the process for you.
1. Confirm your formula from top to bottom: total rev - cost of rev = gross profit - op exp = op inc + net non op + other inc = pretax inc - taxes = net income.
2. Start with Total Revenue. Go to revenue estimate portion of photo. the Analysis tab. gives you the revenue estimates for CURRENT YEAR and NEXT YEAR. Use the HIGH estimates INCLUSIVE of the value of computer upgrades. For the 3rd year, photo gives you the PER ANNUM GROWTH ESTIMATE FOR THE NEXT FIVE YEARS (bottom of the page). Simply multiply this % with the NEXT YEAR revenue estimate to calculate the total revenue figure for the 3rd year. Revenues are done.
3. For all other NON-SUBTOTAL categories (cost of rev, op exp, net non op, other inc and taxes), simply take the % for your base year and apply that to the next 3 years.
4. Take cost of rev/rev for the base year and apply that % to Years 1-3.
5. Take op exp/gross profit for the base year and apply that % to Years 1-3
6. Take net non op/op inc for base year and apply that % to Years 1-3
7. Take other inc/op inc for base year and apply that % to Years 1-3
8. Take taxes/pretax inc for base year and apply that % to Years 1-3
This will give you the foundation for your statements as you are relying on your base year data. From there, you may make additional manual adjustments if your project dictates (ie increasing or decreasing cost of rev or op exp %) or if you are starting with a negative profit (ie increasing or decreasing net non op inc or other inc %). In the end, you want to see a nice and steady increase in net income. That is the goal.
For the the discussion, you need to provide your reasoning and assumptions along with the overall % increases for revenues and net income. This is your (End-Beg)/Beg formula from Comp 1. You already have that reasoning for revenues above (you used the HIGH estimates from photo inclusive of the 2billion value of computer upgrades project). For all other categories, you simply used the same percentages for your base year as you do not expect material changes, unless you made additional manual adjustments. In that case, you will need to explain those adjustments. Finish the discussion with a plug as to your project and the value it will bring.
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Macroeconomics

Authors: Andrew B. Abel, Ben S. Bernanke, Dean Croushore, Ronald D. Kneebone

6th Canadian Edition

978-0321675606

Students also viewed these Finance questions