Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The case study is about capital budgeting and investment decision. **NOTE** 1 paragraph per question is enough. Thanks Part (C) 1. What is sensitivity analysis?

image text in transcribed

The case study is about capital budgeting and investment decision.

**NOTE** 1 paragraph per question is enough. Thanks

Part (C)

1. What is sensitivity analysis?

2. Perform a sensitivity analysis on the unit sales, salvage value, and WACC for the project. Assume that each of these variables deviates from its base-case, or expected value by plus or minus 10%, 20%, and 30%. Calculate NPV for each case (21 NPV in total: 7 NPV for change in unit sale; 7 NPV for change in salvage value; and 7 NPV for change in WACC), then draw a graph with three lines (one for Unit Sales, one for Salvage Value, and one for WACC, all three lines in the same graph). At the end, perform a sensitivity analysis for the project (what you have seen from your graph, what conclusion you can make?).

3. What can we learn from sensitivity analysis the goal of sensitivity analysis?

4. What is the primary weakness of sensitivity analysis? What are its primary advantages?

5. Your reflection on the sensitivity analysis (what it tells you about the project)?

35% 145,250.00 $ MACRS Tax depreciation (MACRS % x CAPEX) 30% 124,500.00 S 25% 103,750.00 $ 10% 41,500.00 S YEAR TOTAL 2 2 0 1 $ Investment Outlays Equipment cost Shiping and installation CAPEX 380,000.00 35000 415,000.00 S $ $ S Increase in inventory Increase in Accounts Payable ANOWC 35,000.00 8,000.00 27,000.00 $ Project Operating Cash Flows Unit sales Price per unit Total revenues Operating cost Deprecitation Total costs EBIT (Operating income) Taxes on operating income Q15% EBIT (1-T) = After tax operating income Add back depreciation Free cash flow after tax S $ $ $ S $ S S $ 230000 1.80 $ 414,000.00 186,300.00 S 145,250.00 $ 331,550.00 $ 82,450.00 $ 12,367.50 $ 70,082.50 $ 145,250.00 $ 215,332.50 S 230000 1.80 S 414,000.00 $ 186,300.00 $ 124,500.00 $ 310,800.00 S 103,200.00 $ 15,480.00 $ 87,720.00 $ 124,500.00 $ 212,220.00 $ 230000 1.80 $ 414,000.00 $ 186,300.00 S 103,750.00 $ 290,050.00 $ 123,950.00 $ 18,592.50 $ 105,357.50 $ 103,750.00 $ 209,107.50 S 230000 1.80 414,000.00 186,300.00 41,500.00 227,800.00 186,200.00 27,930.00 158,270.00 41,500.00 199,770.00 $ Project Termination Cash Flows Salvage value Tax on salvage value After tax salvage value ANOWC = Recovery of NOWC Project Net Free cash flow after tax Present value factor = 1/(1-10%)'n Present value of cash flow - PVF x net free cash flow $ $ $ $ 209,107.50 $ 0.751314801 157,105,56 S 40,000.00 (6,000.00 34,000.00 27,000.00 260,770.00 0.683013455 178,109.42 $264,360.23 $ (442,000.00) $ 1 (442,000.00) S 215,332.50 $ 0.909090909 195,756.82 $ 212,220.00 $ S 0.826446281 175,388.43 $ S NPV = total Present value of cash inflow - present value of cash out flow S 264,360.23 IRR 35%

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

Technology And Finance Challenges For Financial Markets Business Strategies And Policy Makers

Authors: Morten Balling, Frank Lierman, Andy Mullineux

1st Edition

041529827X, 978-0415298278

More Books

Students also viewed these Finance questions