While attending college, you want to use your free time to start a new business. Your first
Fantastic news! We've Found the answer you've been seeking!
Question:
Bundt cakes. Before you decide to execute this idea, you would like to do a capital budgeting analysis to see if this is a
profitable business. Here are your main assumptions:
Transcribed Image Text:
• You will keep the bakery open for 12 year. • To start up, you have to invest $150,000 for your fixed assets. • Revenue in first year is $120,000, and should grow by 3% per year. • Rent of the storefront costs $35,000 per year, and should grow by 2% per year. • COGS (food supplies, kitchen equipment, silvers, etc) cost $30,000 per year. Employee salaries cost $40,000 per year. • Utilities cost $5,000 per year. • You will depreciate your fixed assets using a straight-line depreciation method. Assuming all your fixed assets have a usable life of 15 years and a salvage value totaling $8,000. • After 12 years in business, you plan to leave the business and sell your fixed assets based on its salvage value. • Income tax rate is 30%. Capital gains tax rate is 15%. (1) If you require at least 10% return, what's NPV and IRR of this investment? (2) Create a NPV profile. (3) Do a sensitivity analysis using 2-input data table. Show NPV as a result of 2 variables that you choose. (4) Do a scenario analysis that includes at least 2 different scenarios and report the summary results for both NPV and IRR. You can decide the input variables (at least 3) and values. ● ● (5) The $150,000 start-up fund is not easy to raise. But luckily you can get a loan from the bank after your parents agree to use their home equity as a collateral. You are able to get the full $150,000 loan amount. The loan will be amortized monthly over 15 years. In other words, the bank requires monthly payment, and the term of the loan is 15 years. The interest rate is 4% for the first 5 years, and 5% for the next 10 years. The monthly payment will change during the loan term, too. Specifically, bank requires a fixed monthly payment for the first 5 years, then the fixed monthly payment steps up 10% starting in year 6 and will remain the same for the rest of the loan life. Build a loan amortization table showing the monthly amortization schedule. • You will keep the bakery open for 12 year. • To start up, you have to invest $150,000 for your fixed assets. • Revenue in first year is $120,000, and should grow by 3% per year. • Rent of the storefront costs $35,000 per year, and should grow by 2% per year. • COGS (food supplies, kitchen equipment, silvers, etc) cost $30,000 per year. Employee salaries cost $40,000 per year. • Utilities cost $5,000 per year. • You will depreciate your fixed assets using a straight-line depreciation method. Assuming all your fixed assets have a usable life of 15 years and a salvage value totaling $8,000. • After 12 years in business, you plan to leave the business and sell your fixed assets based on its salvage value. • Income tax rate is 30%. Capital gains tax rate is 15%. (1) If you require at least 10% return, what's NPV and IRR of this investment? (2) Create a NPV profile. (3) Do a sensitivity analysis using 2-input data table. Show NPV as a result of 2 variables that you choose. (4) Do a scenario analysis that includes at least 2 different scenarios and report the summary results for both NPV and IRR. You can decide the input variables (at least 3) and values. ● ● (5) The $150,000 start-up fund is not easy to raise. But luckily you can get a loan from the bank after your parents agree to use their home equity as a collateral. You are able to get the full $150,000 loan amount. The loan will be amortized monthly over 15 years. In other words, the bank requires monthly payment, and the term of the loan is 15 years. The interest rate is 4% for the first 5 years, and 5% for the next 10 years. The monthly payment will change during the loan term, too. Specifically, bank requires a fixed monthly payment for the first 5 years, then the fixed monthly payment steps up 10% starting in year 6 and will remain the same for the rest of the loan life. Build a loan amortization table showing the monthly amortization schedule.
Expert Answer:
Answer rating: 100% (QA)
SOLUTION Sure Id be happy to help you with your capital budgeting analysis 1 NPV and IRR Using the assumptions given we can calculate the NPV and IRR of the investment as follows NPV Year 1 120000 rev... View the full answer
Related Book For
Making Hard Decisions with decision tools
ISBN: 978-0538797573
3rd edition
Authors: Robert Clemen, Terence Reilly
Posted Date:
Students also viewed these finance questions
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
Your mother made delicious Muffins from scratch, and she left you the recipe. Everyone raved about them. Now, you are also making Muffins just as good as moms. But, you dont want to divulge the...
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
Holly needs $21,800 worth of new equipment for his shop. He can borrow this money at a discount rate of 11% for a year. Find the amount of the loan Holly should ask for so that the proceeds are...
-
Prepare a flexible budget for 10,000, 12,000, and 14,000 units of output, using the following information: Variable costs Direct materials.......$10.00 per unit Direct labor...........$3.00 per unit...
-
One cup of nuts that contains exactly half peanuts and half cashews is added to a bowl of nuts that is exactly one third peanuts, one third cashews, and one third almonds. This results in a three-cup...
-
With the same revolutions/minute, the ratio of power developed by 4-stroke engine to that developed by 2 -stroke engine of same bore and stroke is (a) 2 (b) 1 (c) \(\frac{1}{2}\) (d) 4
-
Vargas Corporation is authorized to issue 20,000 shares of $50 par value, 10% preferred stock and 125,000 shares of $3 par value common stock . On January 1, 2010, the ledger contained the following...
-
Assume that after initial recognition, Blossom uses the revaluation model (asset adjustment method) to measure its intangible assets. Prepare the entries required on December 31, 2025, December 31,...
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-6. On December 12, Irene purchased the building where her store is located. She paid...
-
Wagner Family The Wagners have saved $5,000 towards their goal to have $50,000 for a down payment on a house in 6 years. They will put the $5,000 in an account along with money they will deposit...
-
In Family law are there any cases relating "obtaining residence" for children.?
-
How does family law in relation to domestic violence reflect changing values in the community?
-
In the movie, Mrs Doubtfire what are the four topics that are shown in the movie that are covered in family law ?
-
Why should we say that Collateralized Debt Obligations (CDO) are the main causes of the sub-prime mortgage crisis in US which ultimately leads to financial tsunami ?
-
create a hypothetical fmcg comapny with hair care, toothpaste, processed foods, beverages and pens as products, describe its production or service process inclusing major cost elements and...
-
Find the value of the variable in the figure. The diagram is not to scale. Volume = 36
-
Suppose that a company has 10.000 outstanding shares in the beginning of the year. On April 1st, the company increases its shares by 6.000. On July 1st, the company increases its shares again, but...
-
Suppose that an analyst for an insurance company is interested in using regression analysis to model the damage caused by hurricanes when they come ashore. The response variable is Property Damage,...
-
The cost-to-loss ratio problem continued . The cost-to-loss ratio problem as shown in Figure 5.26 may be considered a simplified version of the actual situation. The protective action that may be...
-
In your own words, explain why the axioms that underlie expected utility are important to decision analysis.
-
External auditors collect consulting fees from the same clients they perform independent audits for, which allows good and close relationship with the clients. True/false
-
To deal with the turmoil caused by the various accounting scandals, the SOX Act was passed in 1999. True/false
-
Auditors should not demand full access to the entire general ledger so that they can be more focused on the audit. True/false
Study smarter with the SolutionInn App