Question
Please show on excel worksheet. Thanks You are thinking of opening an internet coffee shop and estimate the following cash flows. The cost of the
Please show on excel worksheet. Thanks
You are thinking of opening an internet coffee shop and estimate the following cash flows.
The cost of the establishment is $1.200,000 for the building and $250,000 for equipment (tax life of 5 years) and both are placed it into service on June 1. The business will earn $42,300 per week in revenue and have cash expenses of $38,000 per week during its twelve years of operation. Assume a 50-week year. The building and equipment will be sold for an after-tax cash disposition value of $600,000 at the end of the 12th year. No other cash flows will occur during the 12 years of operation. Using a 25 percent tax rate, and a 9 percent cost of money, what is the net present value of this business? Net present value______________________
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started