Hi Bhargav,
Please find the answer below and please let me know if you find it correct and understandable :
NPV = PV of Net cash inflows - PV of Net cash outflows = $532,928 - $450,000 = $82,928.(Please note that I've taken 10% as the required rate of return for all the PV calculation as it is missing in question)
Now, Lets calculate PV of Net cash Inflows :
First, We have Before- tax cash inflow per year of $237,000 - $85,000 = $152,000
After-tax cash flow = 152,000*(1- .30) = $106,400
Now adding Depreciation tax shield of $27,000 [which is calculated as $450,000/5 = 90,000 Dep. each year and Tax shield is $27000 (30% of 90,000) ]
Therefore, After-Tax Annual cash inflow per year = $106,400 + $27,000 = $133,400Now, We need to know the
After-tax value of selling the equipment that is $63,000 - Tax liability on gain = 63,000 - $18,900 (30% of $63,000) = $44,100. [Note:
Tax is on whole 63,000 gain as we have applied whole dep. to asset and its book value is zero ]
Therefore,
Let's calculate NPV of these cash inflows :PV of Annual cash inflow for 5 years =$133,400 * 3.79 = $505,586
PV of Disposal value of equipment at the end of 5th year = $44,100 * .62 = $27,342
Total PV of Net cash inflow = $505,586 + $27,342 = $532,928Note: All these PV calculations would change if required rate of return is changed and so would be the NPV. I hope you understood the concept here, and please feel free to correct me if you find any mistake in my answer.
Thanks
Shubham Sharma
------------------------------
Shubham Sharma
Unemployed
Gurugram
India
------------------------------
Original Message:
Sent: 05-18-2022 01:58 PM
From: Bhargav Desai
Subject: Could anyone help
Quad Company is considering buying new equipment costing $450,000 to update its tailgating business. Management anticipates that the machine will produce cash sales of $237,000 each year over the next five years. Annual cash expenses are projected to be $85,000. Quad plans to depreciate the new equipment using the straight-line method over the same five year period. Quad will then sell the asset for $63,000 at the end of year 5. Do not deduct salvage value when calculating depreciation. Quad's combined income tax rate is 30%. Determine the net present value for the investment.