Answered step by step
Verified Expert Solution
Question
1 Approved Answer
begin{tabular}{|l|l|r|} hline & multicolumn{1}{|c|}{ A } & B hline & multicolumn{2}{|c|}{ ICE CREAM TRUCK LOAN PAYMENT } 1 & multicolumn{1}{|c|}{ CALULATOR }
\\begin{tabular}{|l|l|r|} \\hline & \\multicolumn{1}{|c|}{ A } & B \\\\ \\hline & \\multicolumn{2}{|c|}{ ICE CREAM TRUCK LOAN PAYMENT } \\\\ 1 & \\multicolumn{1}{|c|}{ CALULATOR } \\\\ \\hline 2 & Total Cost of Ice Cream Truck & \\( \\mathbf{6 5 0 0 0} \\) \\\\ \\hline 3 & Annual Interest Rate & \\( \\mathbf{0 . 0 5} \\) \\\\ \\hline 4 & Loan Duration (Years) & \\( \\mathbf{5} \\) \\\\ \\hline 5 & Number of Payments per Year & \\( \\mathbf{2 4} \\) \\\\ \\hline 6 & Payment Amount & \\\\ \\hline 7 & Total Paid & \\\\ \\hline 8 & Total Loan Interest & \\\\ \\hline \\end{tabular} 41. Create a formula in cell \\( \\mathbf{B} \\mathbf{6} \\) which uses the \\( \\mathbf{P M T} \\) function to calculate the payment amount. Assume that the payments are made at the end of the payment period. Ensure that the formula returns a positive value. Your formula must use references to cells B2, B3, B4, and B5 for full marks. 42. Create a formula in cell \\( \\mathbf{B 7} \\) that determines the total amount paid over the duration of the loan. Do not use any functions in your formula. Your formula must use references to cells B4, B5, and B6 for full marks. 43. Create a formula in cell B8 that determines the total amount of interest paid over the duration of the loan. Do not use any functions in your formula. Your formula must use references to cells B2 and B7 for full marks
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