Business > EXAM > C268 Practice Exam Questions and Answers (A+) (All)

C268 Practice Exam Questions and Answers (A+)

Document Content and Description Below

C268 Practice Exam Questions and Answers (A+)>Scenario: You have decided to purchase a new car. You plan to take out a loan to pay for the car. The loan amount is $18,900. You will pay an interest rat... e of 6.5% and plan to pay off the car in 48 months. You want to calculate the total amount of money and the total amount of interest you will pay over the course of the loan. To help you with these calculations, you decide to construct an amortization table. An amortization table provides details about the payment, interest amount, principal amount, and loan balance for every month of the loan. Perform the tasks below to complete the amortization table and loan summary calculations. 1. Calculate the payment amount for the loan in cell C15. Reference the cells containing the appropriate loan information as the arguments for the function you use. Cells C20–C67 in the "Payment" column are populated with the payment amount from cell C15. =PMT(C13/12,C12,C11) 2. Calculate, in cell D20, the interest amount for period 1 by multiplying the balance in period 0 (cell F19) by the loan interest rate (cell C13) divided by 12. Dividing the interest rate by 12 results in the monthly interest rate. This formula is reusable. The interest for a given period is always the monthly interest rate times the balance from the previous period. [Show More]

Last updated: 1 year ago

Preview 1 out of 10 pages

Add to cart

Instant download

We Accept:

We Accept
document-preview

Buy this document to get the full access instantly

Instant Download Access after purchase

Add to cart

Instant download

We Accept:

We Accept

Reviews( 0 )

$15.00

Add to cart

We Accept:

We Accept

Instant download

Can't find what you want? Try our AI powered Search

OR

REQUEST DOCUMENT
43
0

Document information


Connected school, study & course


About the document


Uploaded On

Apr 26, 2021

Number of pages

10

Written in

Seller


seller-icon
PROF

Member since 3 years

142 Documents Sold


Additional information

This document has been written for:

Uploaded

Apr 26, 2021

Downloads

 0

Views

 43

Document Keyword Tags

Recommended For You

Get more on EXAM »

$15.00
What is Browsegrades

In Browsegrades, a student can earn by offering help to other student. Students can help other students with materials by upploading their notes and earn money.

We are here to help

We're available through e-mail, Twitter, Facebook, and live chat.
 FAQ
 Questions? Leave a message!

Follow us on
 Twitter

Copyright © Browsegrades · High quality services·