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...
-
Refer to the information in E18-15 for Zdon Inc. Assume that the company follows the taxes payable method of accounting for income taxes under ASPE. During the year, Zdon Inc. made tax instalment...
-
Discuss the similarities and differences between the discounted dividend and corporate valuation models.
-
The equilibrium constant of a chemical reaction does not depend upon (a) The temperature at equilibrium (b) The pressure at equilibrium (c) Neither (a) nor (b) (d) Both (a) and (b).
-
Merit Bay Communications operates a customer call center that handles billing inquiries for several large insurance fi rms. Since the center is located on the outskirts of town, where there are no...
-
Discuss techniques for achieving fault tolerance and high availability in virtualized environments. How do technologies like VMware vSphere Fault Tolerance and Microsoft Hyper-V Replica ensure...
-
Write Regular Expressions for the following grammar rules: 1. Conjunction (CCD, CX) - must start with a noun (NC, NN) / pronoun (PPR, PRL) and end with noun and pronoun 2. Adjective (JJ) - lookbehind...
-
Why has Gatorade been so successful in the sports drink market?
-
In the Heckscher-Ohlin model, as trade occurs in a capital-abundant country, increased imports will force domestic import- competing firms to decrease prices and production. Labor and capital will...
-
In February 2 0 1 6 , hackers targeted the central bank of Bangladesh and exploited vulnerabilities in SWIFT, the global financial system s main electronic payment messaging system, trying to steal...
-
Explore the significance of intermedial allusions in multimedia storytelling, such as in graphic novels or hypertext fiction, and their implications for narrative coherence and interpretation.
-
You observe the price of a latte changes from $4 to $5. Instructions: Round your answer to one decimal place. If you are entering a negative number include a minus sign. a. What is the percentage...
-
You are planning on installing a set of solar panels which will cover 56.96 ft2. You live in East Lansing Michigan. For the entire month of December how many Btu's can you expect to gather if your...
-
Perform the indicated operations. In designing a cam for a fire engine pump, the expression is used. Simplify this expression. (3) (3 4 32
-
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.)...
-
Prove that \(C_{P}>C_{V}\), where the notations have their usual meanings.
-
In a chemical process plant, water at 67C is pumped from a storage tank at the rate of 20,000 kg/hr. The motor for the pump expenses work at the rate of 1.5 hp. The water passes through a heat...
-
\(5 \mathrm{~kg}\) of \(\mathrm{N}_{2}\) is heated from an initial state of \(37^{\circ} \mathrm{C}\) and \(101.33 \mathrm{kPa}\) until its temperature reaches \(237^{\circ} \mathrm{C}\). Calculate...
Study smarter with the SolutionInn App