Instructions NP EX16 9a Word View Help ert Design Layout References Mailings Review Tell me what you want to do PROJECT STEPS You are a part-time manager for The Mobile Vegan, a food truck catering to vegan diners in Portland, Oregon. Jessica Rosen, the owner of the business, wants to expand by adding other food trucks in Portland and the surrounding area. Whether she purchases new trucks or takes over an existing food truck business with an established clientele, she needs a loan to cover the cost of the trucks. She has asked for your help updating the workbook she created to analyze the loan information and forecast sales. 1. Switch to the Loan Scenarios worksheet, and then calculate the monthly payment for the Add 1 Truck scenario as follows: In cell D11, enter a formula using the PMT function to calculate the monthly payment for a loan. a. b. Use the inputs listed under the Add 1 Truck loan scenario in cells DS, D7, and D9. (Hint: The result will be displayed as a negative number to reflect the negative cash flow of a loan payment.) Calculate the monthly interest rate for the Add 2 Trucks scenario as follows 2. In cell E7, enter a formula using the RATE function to calculate the monthly interest rate for a loan. a. Use the inputs listed under the Add 2 Trucks loan scenario in cells E9, E11, and Es. (Hint: Assume the present value of the loan is the loan amount shown in cell ES.) b. Calculate the loan amount for the Add 3 Trucks scenario as follows: 3. NP EX16,9a FURNERMARQUIS 1 (Protected View-Excel Fil Home Insert Page LayoutFormulas Data Review View Help ell me what you want to do PROTECTED VIEW Be careful -files from the Internet can contain vinuses.Unless you need to edit, it's safer to stay in Protected Vew Enable Editing The Mobile Vegan Expansion Plan 2 Loan Scenarios Take Over Add 3 Trucks Add 1 Truck Add 2 Trucks $112,000 0 00% Conditions Loan amount Annual interest rate Monthly interest rate Loanpenod n years 500,000 5 00% 56,000 450% 450% 0 44% 0500 042 % _ 5 60 1/2/2019 - 84 1/2/2019 ($2,300) 9 Loan period in months 10 122019 12/20 1/2/2019 Start date of Ioan ($5,500) ($1,800) 11 Monthly Payment DueEZOS122019 12 13 14 16 18 19 20 21 Amortization Depreciation Income Statement Documentation Loan fcenarios