Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Scenario - You are the owner of a small food truck business Aloha Food Truck. Your business is doing well however you decided it is
Scenario - You are the owner of a small food truck business Aloha Food Truck. Your business is doing well however you decided it is time to purchase a new food truck as wear and tear is affecting the running of your business. You approach your bank for a $60,000 loan. The bank came back with an interest rate of 5% for 5 years under the condition that you can show that your business is viable and making enough profit to pay off the loan. You will show proof by providing your income statement for the year. You also want to find out what your monthly payment would be for the new truck. In order to do so, you need to: Step 1. Calculate the Monthly Payment for the loan and the Total Amount Repaid by utilizing a spreadsheet function you have learned in previous themes in the New Truck Upgrades sheet. Step 2. You figured that you need to make at least $20,000 Net Profit for the 4th Quarter to show the bank that your business is continuously making enough to pay for the loan on your income statement. Figure out the amount of sales for 4th quarter. Select
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