Sub-Prime Loan Company: Project's NPV for new office
Sub-Prime Loan Company is thinking of opening a new office, and the key data are shown below. The company owns the building that would be used, and it could sell it for $100,000 after taxes if it decides not to open the new office. The equipment for the project would be depreciated by the straight-line method over the project's 3-year life, after which it would be worth nothing and thus it would have a zero salvage value. No new working capital would be required, and revenues and other operating costs would be constant over the project's 3-year life. What is the project's NPV? (Hint: Cash flows are constant in Years 1-3.)
WACC 10.0%
Opportunity cost $100,000
Net equipment cost (depreciable basis) $65,000
Straight-line deprec. rate for equipment 33.333%
Sales revenues, each year $123,000
Operating costs (excl. deprec.), each year $25,000
Tax rate 35%
Solution Summary
I did the work in excel so you could see the process. Click on cells to see the formulas and computations.
$2.19 
This answer includes:
- Plain text
- Cited sources when necessary
- Attached file(s)
- sub prime loan company NPV.xlsx
Active since 2010
Responses 2329 | Videos 11
"What a great answer with lightning speed!!! Genius!!!! Thank you so much! Wish you all the best, healthy and wealthy all the time!!"
"You gave a great explanation on the pilot/project budget. However,I think I am getting confused on how to separate the project budget from the operating budget. I was told I need two separate totals. How should the operating budget look? Thank you!"
"Thank you so much!!"
"THANK YOU SO VERY MUCH, LOOKS GREAT!!!!!!!"
"Thank you very much!!"