Answered step by step
Verified Expert Solution
Link Copied!

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 }

image text in transcribedimage text in transcribed

\\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

blur-text-image

Get Instant Access to Expert-Tailored 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

Apple Marketing Audit And New Service Product Plan

Authors: Sherry King

1st Edition

3656610797, 978-3656610793

More Books

Students also viewed these Accounting questions

Question

3. Identify challenges to good listening and their remedies

Answered: 1 week ago

Question

4. Identify ethical factors in the listening process

Answered: 1 week ago