Answered step by step
Verified Expert Solution
Link Copied!

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. Select a function of what-if analysis to show how you

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Statistics For Business And Economics

Authors: David R. Anderson, Dennis J. Sweeney, Thomas A. Williams

11th Edition

978-0324783254, 324783256, 978-0324783247, 324783248, 978-0538481649

Students also viewed these Accounting questions