Please submit one Excel file for this project. In this file you may create multiple tabs for different models. Make your model flexible, easy to update, and organized. 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 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. Please submit one Excel file for this project. In this file you may create multiple tabs for different models. Make your model flexible, easy to update, and organized. 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 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