Answered step by step
Verified Expert Solution
Question
1 Approved Answer
hello, i am not sure if i am doing #1 correct so far. what should be the correct formula and correct monthly payment due total
hello, i am not sure if i am doing #1 correct so far. what should be the correct formula and correct monthly payment due total for add 1 truck? The Mobile Vegan Expansion Plan PROJECT STEPS 1. 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. Switch to the Loan Scenarios worksheet, and then calculate the monthly payment for the Add 1 Truck scenario as follows: a. In cell D11, enter a formula using the PMT function to calculate the monthly payment for a loan. 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.) 2. Calculate the monthly interest rate for the Add 2 Trucks scenario as follows: a. In cell E7, enter a formula using the RATE function to calculate the monthly interest rate for a loan. b. 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 E5.) The Mobile Vegan Expansion Plan Loan Scenarios \begin{tabular}{|l|rrr|} \hline Conditions & Add 1 Truck & Add 2 Trucks & Add 3 Trucks \\ \hline Loan amount & $56,000 & $112,000 & \\ \hline Annual interest rate & 4.50% & 0.00% & 4.50% \\ \hline Monthly interest rate & 0.42% & 0.44% \\ \hline Loan period in years & 5 & 7 \\ \hline Loan period in month & 60 & 1/2/2019 & 1/2/2019 \\ \hline Start date of loan & 1/2/2019 & ($2,300) \\ \hline Monthly Payment Due & =PMT(D7*|12, D9/12, D5) & 74 \\ \hline \end{tabular}
hello, i am not sure if i am doing #1 correct so far. what should be the correct formula and correct monthly payment due total for add 1 truck?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started