Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please do it on excel 5. Consider the following projections for an investment in a facility that runs spin classes. All growth rates are nominal
Please do it on excel
5. Consider the following projections for an investment in a facility that runs spin classes. All growth rates are nominal growth rates. The data for this question is loaded in the Excel template file. The project expects 1,100 participants in Year 1 and expects this number to grow at 5.00% per year (Years 2 to 5) In year 1, each participant is projected to pay an annual fee of $220. This fee per participant is expected to grow at 3.00% per year (Years 2 to 5) Instructor wages in Year 1 are expected to be $30,000. These wages are expected to grow at the rate of inflation of 2.00% per year (Years 2 to 5) The upfront cost to renovate the facility will be $125,000, which will be depreciated to zero in equal increments over 5 years Each year over Years 1 to 5, 80 new bikes will be purchased. The cost of each bike in Year 1 will be $500 and will increase with inflation. Because the bikes only last one year, treat the bike cost as an operating cost, rather than a capital item. So, no depreciation is required. Also, assume the first set of bikes are purchased at the end of Year 1 After Year 5, assume that cash flows will grow at a constant rate of 3.00% each year The tax rate is 21% and the discount rate is 12% per year in nominal terms What is the net present value of the investment? 5. Consider the following projections for an investment in a facility that runs spin classes. All growth rates are nominal growth rates. The data for this question is loaded in the Excel template file. The project expects 1,100 participants in Year 1 and expects this number to grow at 5.00% per year (Years 2 to 5) In year 1, each participant is projected to pay an annual fee of $220. This fee per participant is expected to grow at 3.00% per year (Years 2 to 5) Instructor wages in Year 1 are expected to be $30,000. These wages are expected to grow at the rate of inflation of 2.00% per year (Years 2 to 5) The upfront cost to renovate the facility will be $125,000, which will be depreciated to zero in equal increments over 5 years Each year over Years 1 to 5, 80 new bikes will be purchased. The cost of each bike in Year 1 will be $500 and will increase with inflation. Because the bikes only last one year, treat the bike cost as an operating cost, rather than a capital item. So, no depreciation is required. Also, assume the first set of bikes are purchased at the end of Year 1 After Year 5, assume that cash flows will grow at a constant rate of 3.00% each year The tax rate is 21% and the discount rate is 12% per year in nominal terms What is the net present value of the investmentStep 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