A friend of yours, Sam, has asked you to assist her in preparing materials to submit...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
A friend of yours, Sam, has asked you to assist her in preparing materials to submit to a potential investor. The analysis you perform will be part of Sam's investment proposal if you think she should move forward. Sam has a passion for cheesecake. She started making them a few years ago, and they are amazing. At first Sam made cheesecakes for friends, but she soon realized there was a market demand for well-made desserts. After perfecting her recipes, Sam began selling custom-order cheesecakes that she made at home and sold via word of mouth. The cheesecakes are now so popular that Sam does not have the equipment to keep up with demand. Therefore, she plans to buy a food truck that is equipped with all the equipment she needs to bake cheesecakes in higher volume, and she will be able to drive the truck to locations throughout Seattle to sell cheesecakes by the slice. If Sam is able to attract an investor, startup costs will be $220,000 in equipment that is depreciable on a 7-year MACRS schedule. Sam's plan is to start and operate the business for 7 years at the end of which time she expects the business to be worth at least $338,390. You expect Sam to have initial working capital needs of $25,000, but these needs will remain proportionate to the expected next-year sales (they will grow at the same rate as sales grow in the subsequent year). You expect sales in the first year to be $75,000 and that sales will grow by 50% per year for three years before leveling off to a 10% per year growth rate. You project annual fixed operating expenses of $25,000 in the first year. These fixed expenses will grow by 10% per year. Your annual variable operating expenses are as follows: cost of goods sold will be 35% of sales, marketing, general, administrative, and all other expenses are expected to be a combined 10% of sales. You expect Sam to pay taxes of 21%. Assume your required return is 15%. Should Sam pursue the project? Prepare a spreadsheet that provides enough information to answer the following questions (no more than a paragraph is needed for each, much less for some): 1. Based on your analysis, will Sam earning a profit? Be sure to briefly explain your response. That is, is it positive in all years? Some years? If not, why not? 2. Will Sam generate a positive operating cash flow? Again, briefly explain your response. 3. Calculate the after-tax salvage value of the business. What is it? (What is the dollar amount?) 4. Determine the total cash flows over the life of the project. Are they positive? Again, explain. 5. Estimate the opportunity's NPV. Your calculations must be done within your spreadsheet using appropriate formulas and cell references. Is the NPV positive or negative? What does it suggest about whether Sam should move froward or not? 6. Consider what happens to cash flows and NPV if Sales are 20% more than expected. Do the same for if sales are 20% less than expected? Your calculations must be such that you simply change one cell (to reflect the change in sales) and your spreadsheet recalculates everything. How does NPV change? 7. What happens to your base NPV calculation if your required return is 18% rather than 15%? 8. What is your recommendation? Should Sam pursue this opportunity? A friend of yours, Sam, has asked you to assist her in preparing materials to submit to a potential investor. The analysis you perform will be part of Sam's investment proposal if you think she should move forward. Sam has a passion for cheesecake. She started making them a few years ago, and they are amazing. At first Sam made cheesecakes for friends, but she soon realized there was a market demand for well-made desserts. After perfecting her recipes, Sam began selling custom-order cheesecakes that she made at home and sold via word of mouth. The cheesecakes are now so popular that Sam does not have the equipment to keep up with demand. Therefore, she plans to buy a food truck that is equipped with all the equipment she needs to bake cheesecakes in higher volume, and she will be able to drive the truck to locations throughout Seattle to sell cheesecakes by the slice. If Sam is able to attract an investor, startup costs will be $220,000 in equipment that is depreciable on a 7-year MACRS schedule. Sam's plan is to start and operate the business for 7 years at the end of which time she expects the business to be worth at least $338,390. You expect Sam to have initial working capital needs of $25,000, but these needs will remain proportionate to the expected next-year sales (they will grow at the same rate as sales grow in the subsequent year). You expect sales in the first year to be $75,000 and that sales will grow by 50% per year for three years before leveling off to a 10% per year growth rate. You project annual fixed operating expenses of $25,000 in the first year. These fixed expenses will grow by 10% per year. Your annual variable operating expenses are as follows: cost of goods sold will be 35% of sales, marketing, general, administrative, and all other expenses are expected to be a combined 10% of sales. You expect Sam to pay taxes of 21%. Assume your required return is 15%. Should Sam pursue the project? Prepare a spreadsheet that provides enough information to answer the following questions (no more than a paragraph is needed for each, much less for some): 1. Based on your analysis, will Sam earning a profit? Be sure to briefly explain your response. That is, is it positive in all years? Some years? If not, why not? 2. Will Sam generate a positive operating cash flow? Again, briefly explain your response. 3. Calculate the after-tax salvage value of the business. What is it? (What is the dollar amount?) 4. Determine the total cash flows over the life of the project. Are they positive? Again, explain. 5. Estimate the opportunity's NPV. Your calculations must be done within your spreadsheet using appropriate formulas and cell references. Is the NPV positive or negative? What does it suggest about whether Sam should move froward or not? 6. Consider what happens to cash flows and NPV if Sales are 20% more than expected. Do the same for if sales are 20% less than expected? Your calculations must be such that you simply change one cell (to reflect the change in sales) and your spreadsheet recalculates everything. How does NPV change? 7. What happens to your base NPV calculation if your required return is 18% rather than 15%? 8. What is your recommendation? Should Sam pursue this opportunity?
Expert Answer:
Answer rating: 100% (QA)
To analyze Sams investment proposal I will create a spreadsheet to calculate the following 1 Profitability ... View the full answer
Related Book For
Management Accounting
ISBN: 978-0132570848
6th Canadian edition
Authors: Charles T. Horngren, Gary L. Sundem, William O. Stratton, Phillip Beaulieu
Posted Date:
Students also viewed these finance questions
-
A health insurance policy pays 60 percent of physical therapy costs after a deductible of $360. In contrast, an HMO charges $23 per visit for physical therapy. How much would a person save with the...
-
You have completed your first meeting with Harper and Riley Evans. You are confident that you now have most of the information you will need to prepare a comprehensive financial plan for them. Beyond...
-
It is July 1, 2023, Jim and Pam Halpert have just left your office after their first interview with you. In preparation for the interview, you had sent them a list of the various documents that they...
-
Return to Better Mousetraps in Problem 18. Suppose the firm can cut its requirements for working capital in half by using better inventory control systems. By how much will this increase project NPV?...
-
Consider Figure 11-10. Suppose that the real interest rate suddenly declines for reasons that have nothing to do with the value of the price level. What happens to the nation's aggregate demand...
-
Find the limit, if it exists, or show that the limit does not exist. x + y? (x, y) (0, 0) Jx2 + y + 1 1 lim
-
The Olympia Manufacturing Company has two producing departments, machining and assembly. Olympia recently automated the machining department. The installation of a computer-aided manufacturing (CAM)...
-
The 2012 balance sheet for Guthrie Corporation revealed the following information: Common stock, $10 par, 50,000 shares issued and outstanding Preferred stock, $100 par, 6%, cumulative stock, 1,000...
-
Drag the function equation on top of the matching graph given the transformation. YA 8 -6 f(x)+2 6 x f(x-2)
-
Prepare a financial analysis. This takes a close look at two corporations, Bayer and Monsanto. Bayer is considering a bid for United States seed company Monsanto (Snider, 2016). For purposes of this...
-
signment 1 - Time Value of Money Question 7 of 8 < - /1 IE ... View Policies Current Attempt in Progress Two friends, Alysha and Linda, are planning for their retirement. Both are 20 years old and ...
-
A single-span highway vehicular bridge will cross a small ravine. The bridge is of a deck- girder type and is of composite steel-concrete construction. Abut. no. 1 4 Bridge Expansion bearing 28-12 x...
-
MWP borrowed the $60,000 on October 1, 2022. MWP must make annual interest payments each September 30 and pay the full note on September 30, 2025. The interest rate on the note is 6%. Can you show me...
-
Please modify the Haaland function shown below Editor- 1 2 3 4 /Users/khaled/Desktop/Haaland.m* function f-Haaland (releps, Re) answer=-1.8*log10 ((releps/3.7)^1.11+6.9/Re); f= (1/answer)^2; end to...
-
You are asked to identify unusual trends in school lunch revenue sat a school district. The district provides you data for one of the school lunch rooms, see chart below. Looking at this data,what...
-
A stock has an average historical return of 11.3 percent and a standard deviation of 20.2 percent. What range of returns would you expect to see approximately two-thirds of the time?
-
To purchase a specialty guitar for his band, for the last two years JJ Morrison has made payments of $102 at the end of each month into a savings account earning interest at 3.06% compounded monthly....
-
You've been asked to take over leadership of a group of paralegals that once had a reputation for being a tight-knit, supportive team, but you quickly figure out that this team is in danger of...
-
How should self-interest be considered when designing incentives?
-
Wallaby Kite Company, a small Melbourne firm that sells kites on the Web, wants a master budget for the three months beginning January 1, 2012. It desires an ending minimum cash balance of $20,000...
-
Prepare the estimated cash receipts and disbursements section of a cash budget (not including the financing section) for October 2011 for the Botanica Company, which sells one product, herbal soap,...
-
Two years ago, a ship owned by a foreign company ran aground during a severe storm and sank at the entrance of a Canadian harbour. The vessel blocked the entrance to the harbour and spilled...
-
Direct labour is often accounted for at the gross wage rate, and the related benefit costs such as employer payroll taxes and employer contributions to health care plans are accounted for as part of...
-
Cubs Incorporated manufactures a product with a selling price of $60 per unit. Units and monthly cost data follow: Cubs Inc. pays all bills in the month incurred. All sales are on account with 50...
Study smarter with the SolutionInn App