(5/5)

Hire Me
(5/5)

Hire Me
(4/5)

Hire Me
(5/5)

Hire Me

In this file, you may create multiple tabs for different models.

INSTRUCTIONS TO CANDIDATES

In this file, you may create multiple tabs for different models. Make your model flexible, easy to update, and organized. While attending college, you want to use your free time to start a new business. Your first idea is to open a bakery shop selling 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: You will keep the bakery open for 8 year.

To start up, you have to invest \$180,000 for your fixed assets. Revenue in first year is \$150,000, and should grow by 3% per year. Rent of the storefront costs \$27,000 per year, and should grow by 2% per year. COGS (food supplies, kitchen equipment, silvers, etc) cost \$25,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 10 years and a salvage value totaling \$8,000. After 8 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 \$180,000 start-up fund is not easy to raise. But luckily you think you can get a loan from the bank after your parents agree to use their home equity as a collateral. You will be able to get the full \$180,000 loan amount. The loan will be amortized monthly over 10 years. In other words, the bank requires monthly payment, and the term of the loan is 10 years.

The interest rate is 4% for the first 5 years, and 5% for the next 5 years. The monthly payment will change during the loan term, too. Specifically, bank requires a fixed monthly payment for the first 5 years, then after these 5 years, the fixed monthly payment increases by 2.5% 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.

Related Questions

. The fundamental operations of create, read, update, and delete (CRUD) in either Python or Java

CS 340 Milestone One Guidelines and Rubric  Overview: For this assignment, you will implement the fundamental operations of create, read, update,

. Develop a program to emulate a purchase transaction at a retail store. This  program will have two classes, a LineItem class and a Transaction class

Retail Transaction Programming Project  Project Requirements:  Develop a program to emulate a purchase transaction at a retail store. This

. The following program contains five errors. Identify the errors and fix them

7COM1028   Secure Systems Programming   Referral Coursework: Secure

. Accepts the following from a user: Item Name Item Quantity Item Price Allows the user to create a file to store the sales receipt contents

Create a GUI program that:Accepts the following from a user:Item NameItem QuantityItem PriceAllows the user to create a file to store the sales receip

. The final project will encompass developing a web service using a software stack and implementing an industry-standard interface. Regardless of whether you choose to pursue application development goals as a pure developer or as a software engineer

CS 340 Final Project Guidelines and Rubric  Overview The final project will encompass developing a web service using a software stack and impleme

Get Free Quote!

431 Experts Online