# Study Of Accounting

Questions1. Use Excel to construct six-year pro forma income statements and calculate the incremental unlevered net income for the first six years. When calculating incremental unlevered net income, should we include all the expenses mentioned in the case? If not, what expenses should we exclude and why? Clearly and concisely state your reasons in the cell E9 of the excel template. If you just forecast the unlevered net income but dont given any explanations on why you exclude certain expenses, a penalty of 30 points will deducted from your grade for the case study.2. Calculate six-year projections for free cash flows. Remember to include cash flows from the income statement and depreciation, changes in net working capital, and capital expenditures or dispositions.Hint: You need to calculate the level of net working capital (NWC) and change in NWC. Pay attention to the timing of NWC.3. Canyon Buff expects that free cash flow from Year 6 onwards will increase at a constant rate of 2%/year into the indefinite future. Calculate PV(terminal value that captures the value of future free cash flows in Year 6 and beyond). That is, calculate the terminal value first, then find its value in Year 0 (today).3Hint: We went over this in Lecture Note 6, so let me briefly review the key points: a. Assuming the cash flows grow at a constant rate g after Year N+1, then Year N TV = (Year N+1 CF)/(r?g) (from growing perpetuity formula). where r is discount rate For example, if {FCF6, FCF7, FCF8, } is a growing perpetuity, then Year 5 TV = Year 6 FCF/(r-g). Similarly, if {FCF7, FCF8, FCF9, } is a growing perpetuity, then Year 6 TV = Year 7 FCF/(r-g).b. We should discount this Terminal Value back to Year 0.4. Determine the NPV of the project. Remember to net out any initial cash outflows.5. Perform a sensitivity analysis by varying the four parameters as follows:Parameter Initial Assumption Worst Case Best Case Sales in Year 1 \$30,000 \$27,000 \$33,000 NPV Sales Growth through Year 6 6% 0% 10% NPV Cost of Goods Sold (% of Sales) 72% 77% 67% NPV Cost of Capital 20% 23% 17% NPVFor example, vary the parameter Sales in Year 1 from the worst case \$27,000 to the best case \$33,000, holding all the other parameters fixed (at the level of initial assumptions). Then fill in the highlighted blank boxes for NPV in Excel (the sheet Sensitivity Analysis)Do the same thing for the other three parameters.Suppose you are the financial manager, if you are asked to use limited resources to refine the assumption on ONLY ONE of the above four parameters, which one should you choose and why? Clearly state the reason. Write your answer in Excel.6. Perform a scenario analysis by simultaneously varying the two parameters below:4Sales Growth through Year 6% Cost of Goods Sold NPV Scenario 1 (Baseline) 5% 71% Scenario 2 6% 72% Scenario 3 8% 73% Scenario 4 9% 74%Which scenario generates the highest NPV? Write your answer in Excel.

Struggling to find relevant content? Order a custom essay on
Study Of Accounting
Let our experts save you the hassle
Calculate the price
Pages (550 words)
\$0.00
*Price with a welcome 15% discount applied.
Pro tip: If you want to save more money and pay the lowest price, you need to set a more extended deadline.
We know how difficult it is to be a student these days. That's why our prices are one of the most affordable on the market, and there are no hidden fees.

Instead, we offer bonuses, discounts, and free services to make your experience outstanding.
Sign up, place your order, and leave the rest to our professional paper writers in less than 2 minutes.
step 1
Fill out the order form and provide paper details. You can even attach screenshots or add additional instructions later. If something is not clear or missing, the writer will contact you for clarification.
s
Get personalized services with GPA Fix
One writer for all your papers
You can select one writer for all your papers. This option enhances the consistency in the quality of your assignments. Select your preferred writer from the list of writers who have handledf your previous assignments
Same paper from different writers
Are you ordering the same assignment for a friend? You can get the same paper from different writers. The goal is to produce 100% unique and original papers
Copy of sources used
Our homework writers will provide you with copies of sources used on your request. Just add the option when plaing your order
What our partners say about us
We appreciate every review and are always looking for ways to grow. See what other students think about our do my paper service.
Education
Thank you so much for all the help, I really appreciate it!
Customer 452631, November 3rd, 2021
Other
GOOD
Customer 452813, July 5th, 2022
Other
great
Customer 452813, July 5th, 2022
Nursing
Customer 452707, July 5th, 2022
Social Work and Human Services
Great Work!
Customer 452587, August 31st, 2021
Nursing
Great! Thanks again!
Customer 452707, July 4th, 2022
Nursing
Thank you MyCoursebay team for your support. With your help I got an A for my past courses
Customer 452635, May 7th, 2022
Other
GREAT
Customer 452813, June 25th, 2022
Human Resources Management (HRM)
Thanks for the prompt delvery.
Customer 452701, January 20th, 2023
Management
Great job
Customer 452643, October 31st, 2021
DISCUSSION D SCIENCE 210
GREAT
Customer 452813, June 28th, 2022
Ethics
thank you
Customer 452493, March 15th, 2021