You and your business partners are considering a car rental business. You expect startup costs to...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
You and your business partners are considering a car rental business. You expect startup costs to be $X,XXX,XXX (where this figure is the same as the last seven digits in your WSU student ID number). In equipment that is depreciable on a seven-year MACRS schedule. You plan to start and operate the business for six years, and at the end of which time you expect to sell all the equipment for $X,XXX,XXX plus $150,000. You have to prepare an additional $30,000 as the working capital for this new business and recycle the working capital at the end of the project. You expect the revenue in the first year to be $300,000, and that revenue will increase by 15% per year. You project annual fixed operating expenses of $75,000 in the first year. These fixed expenses will grow by 5% per year. Your annual variable operating costs are expected to be 40% of revenue. You expect to pay taxes of 15%. Assume your required return is 8%. Prepare an excel spreadsheet to respond to the following prompts: 1. Prepare pro forma income statements and operating cash flow projections. (20%) 2. Estimate the total cash flows from asset/project for this opportunity. (Hint: Complete the CFFA table. In other words, calculate the OCF, NCS, and change in NWC.) (20%) 3. Estimate the opportunity's NPV. Would you start up this business line in the baseline situation? (Hint: Is the project's NPV>0?) (10%) 4. Sensitivity Analysis: what happens to cash flows and NPV if the revenue is 15% more than expected. What if the revenue is 15% less than expected? Would you launch this project after the sensitivity analysis? (Hint: Compare the NPVs you got and respond with a short answer. If yes, why? If no, why not?) (25%) You and your business partners are considering a car rental business. You expect startup costs to be $X,XXX,XXX (where this figure is the same as the last seven digits in your WSU student ID number). In equipment that is depreciable on a seven-year MACRS schedule. You plan to start and operate the business for six years, and at the end of which time you expect to sell all the equipment for $X,XXX,XXX plus $150,000. You have to prepare an additional $30,000 as the working capital for this new business and recycle the working capital at the end of the project. You expect the revenue in the first year to be $300,000, and that revenue will increase by 15% per year. You project annual fixed operating expenses of $75,000 in the first year. These fixed expenses will grow by 5% per year. Your annual variable operating costs are expected to be 40% of revenue. You expect to pay taxes of 15%. Assume your required return is 8%. Prepare an excel spreadsheet to respond to the following prompts: 1. Prepare pro forma income statements and operating cash flow projections. (20%) 2. Estimate the total cash flows from asset/project for this opportunity. (Hint: Complete the CFFA table. In other words, calculate the OCF, NCS, and change in NWC.) (20%) 3. Estimate the opportunity's NPV. Would you start up this business line in the baseline situation? (Hint: Is the project's NPV>0?) (10%) 4. Sensitivity Analysis: what happens to cash flows and NPV if the revenue is 15% more than expected. What if the revenue is 15% less than expected? Would you launch this project after the sensitivity analysis? (Hint: Compare the NPVs you got and respond with a short answer. If yes, why? If no, why not?) (25%)
Expert Answer:
Related Book For
Microeconomics An Intuitive Approach with Calculus
ISBN: 978-0538453257
1st edition
Authors: Thomas Nechyba
Posted Date:
Students also viewed these finance questions
-
(CMA, adapted) Roletter Company makes and sells artistic frames for pictures of weddings, graduations, and other special events. Bob Anderson, the controller, is responsible for preparing Roletters...
-
Allen Corporation reports the following amounts in its first three years of operations. The difference between taxable income and accounting income is due to one reversing difference. The tax rate is...
-
Townsend Chemical Company makes a variety of cosmetic products, one of which is a skin cream designed to reduce the signs of aging. Townsend produces a relatively small amount (15,000 units) of the...
-
Discuss the sampling strategy and technique to be used. Develop a hypothetical research scenario that would necessitate the use of the Action Research Approach and a Posttest With a Historical...
-
Consider the unadjusted trial balance of Princess, Inc., at August 31, 2012, and the related month-end adjustment data. Adjustment data at August 31, 2012, include the following: a. Accrued...
-
Even method: 1- Algorithm Compare between recursion and iteration 2- Memory representation (Ex: EVEV (0,10)) recursion iteration
-
You are told that the current 90-day bank bill rate is 3.2% p.a., 180-day bank bill rate is 2.9% p.a. and 270-day bank bill rate is 2.7% p.a. Required: (a) Calculate exactly the 90-day forward 90-day...
-
A surveyor uses an instrument called transil which gives the angle of elevation or depression of a certain object of known height. How far is the surveyor using a 2m transil from a pole 20m high?
-
a. Given the following: Ca = $130, Ig = $60, Xn = $10, and G = $40, what is the economys equilibrium GDP? b. If real GDP in an economy is currently $250, will the economys real GDP rise, fall, or...
-
Hannah and Dawson have both invested money in savings accounts with APYs of 3.2%. If Hannah's account has a balance of $31,000 and Dawson's account has a balance of $42,000, how much more interest...
-
French gunsmith Honor Blanc developed a process of manufacturing standardized musket parts that were interchangeable with other muskets. Who brought this idea back to the United States? Group of...
-
please help me with this. I am looking for the Javascript answer please e# name dob address hireDate EMPLOYEE ID position [Driver, Mechanic] license status [Available, On-leave] TRIP tripNumber ID...
-
Please explain how this is possible and why (x- x0) Ex + 21) maz %3D 4.
-
Why did management adopt the new plan even though it provides a smaller expected number of exposures than the original plan recommended by the original linear programming model?
-
The U.S. tax code subsidizes housing through a deduction of mortgage interest. For new homeowners, mortgage interest makes up the bulk of their housing payments which tend to make up about 25% of a...
-
In this exercise, we are working with the concept of an elasticity of substitution. This concept was introduced in part B of the Chapter. Thus, this entire question relates to material from part B,...
-
Suppose you are a farmer whose land produces 50 units of food this year and is expected to produce another 50 units of food next year. (Assume that there is no one else in the world to trade with.)...
-
Bright Horizons Skilled Nursing Facility, an investor-owned company, constructed a new building to replace its outdated facility. The new building was completed on January 1, 2015, and Bright...
-
Great Forks Hospital reported net income for 2015 of \($2.4\) million on total revenues of \($30\) million. Depreciation expense totaled \($1\) million. a. What were total expenses for 2015? b. What...
-
What is the difference between long-term debt and current portions of long-term debt?
Study smarter with the SolutionInn App