Written by students who passed Immediately available after payment Read online or as PDF Wrong document? Swap it for free 4.6 TrustPilot
logo-home
Exam (elaborations)

C268 Practice Exam Questions and Answers (Complete Solution)

Rating
-
Sold
-
Pages
17
Grade
A+
Uploaded on
16-07-2022
Written in
2021/2022

C268 Practice Exam Questions and Answers (Complete Solution) Amortiza tion 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 rate 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. =F19*0.65/12 3. Copy the interest amount calculation down to complete the "Interest" column of the amortization table. Ctrl + c then double click the bottom right corner 4. Calculate, in cell E20, the principal amount for period 1. The principal amount is the difference between the payment amount (cell C20) and the interest amount (cell D20) for period 1. Construct your formula in such a way that it can be reused to complete the "principal" column of the amortization table. =C20-D20 5. Copy the principal amount calculation down to complete the "principal" column of the amortization table. Ctrl + c then double click the bottom right corner 6. Calculate, in cell F20, the balance for period 1. The balance is the difference between the balance for period 0 (cell F19) and the principal amount for period 1 (cell E20). This formula is reusable. The balance is always calculated as the difference between the balance from the previous period and the principal amount for the current period. =F19-E20:E20 7. Copy the balance amount calculation down to complete the "Balance" column of the amortization table. Ctrl + c then double click the bottom right corner 8. Calculate, in cell G12, the total amount paid by multiplying the payment amount (cell C15) by the term of the loan (cell C12). =C15*C12 9. Calculate the total interest paid in cell G13. The total interest paid is the sum of all interest paid in the "Interest" column of the amortization table. =SUM(D20:D67) 10.Check to see if the total interest calculation in the amortization table is correct. The total interest paid is also equal to the difference between the total amount paid over the course of the loan and the original loan amount. Insert a formula into cell G14 to calculate the difference between the total amount paid and the original loan amount. Notice the negative sign associated with the original loan amount. This value should equal the total interest calculated using the amortization table =G12+C11 11. Assume you have made the first 36 payments on your loan. You want to trade the car in for a new car. You believe that you can sell your car for $4000. Will this cover the balance remaining on the car in period 36? Answer either "Yes" or "No" in cell G15 from the drop-down menu.

Show more Read less
Institution
Course

Content preview

C268 Practice Exam Questions
and Answers (Complete Solution)

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 6.5% interest and will pay off the car in 48 months. You are
interested in calculating 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,
principle amount, and loan balance for every month of the loan. Complete the amortization
table and the summary calculations below.

Loan Amount -$18,900.00 Loan Summary
Term (months) 48 Total Amount Paid $21,514.21
Interest Rate 6.50% Total Interest Paid $2,614.21
SUM Check Calculation $2,614.21
Payment $448.21 Buy new in Period 36? No



Period Payment Interest Principle Balance
0 $18,900.00
1 $448.21 $102.38 $345.84 $18,554.16
2 $448.21 $100.50 $347.71 $18,206.45
3 $448.21 $98.62 $349.59 $17,856.86
4 $448.21 $96.72 $351.49 $17,505.37
5 $448.21 $94.82 $353.39 $17,151.98
6 $448.21 $92.91 $355.31 $16,796.67
7 $448.21 $90.98 $357.23 $16,439.44
8 $448.21 $89.05 $359.17 $16,080.27
9 $448.21 $87.10 $361.11 $15,719.16
10 $448.21 $85.15 $363.07 $15,356.10
11 $448.21 $83.18 $365.03 $14,991.06
12 $448.21 $81.20 $367.01 $14,624.05
13 $448.21 $79.21 $369.00 $14,255.05
14 $448.21 $77.21 $371.00 $13,884.06
15 $448.21 $75.21 $373.01 $13,511.05
16 $448.21 $73.18 $375.03 $13,136.02
17 $448.21 $71.15 $377.06 $12,758.96
18 $448.21 $69.11 $379.10 $12,379.86
19 $448.21 $67.06 $381.16 $11,998.70
20 $448.21 $64.99 $383.22 $11,615.48
21 $448.21 $62.92 $385.30 $11,230.19
22 $448.21 $60.83 $387.38 $10,842.81
23 $448.21 $58.73 $389.48 $10,453.33
24 $448.21 $56.62 $391.59 $10,061.74
25 $448.21 $54.50 $393.71 $9,668.02
26 $448.21 $52.37 $395.84 $9,272.18
27 $448.21 $50.22 $397.99 $8,874.19

,28 $448.21 $48.07 $400.14 $8,474.05
29 $448.21 $45.90 $402.31 $8,071.74

, 30 $448.21 $43.72 $404.49 $7,667.25
31 $448.21 $41.53 $406.68 $7,260.56
32 $448.21 $39.33 $408.88 $6,851.68
33 $448.21 $37.11 $411.10 $6,440.58
34 $448.21 $34.89 $413.33 $6,027.25
35 $448.21 $32.65 $415.56 $5,611.69
36 $448.21 $30.40 $417.82 $5,193.87
37 $448.21 $28.13 $420.08 $4,773.79
38 $448.21 $25.86 $422.35 $4,351.44
39 $448.21 $23.57 $424.64 $3,926.80
40 $448.21 $21.27 $426.94 $3,499.85
41 $448.21 $18.96 $429.26 $3,070.60
42 $448.21 $16.63 $431.58 $2,639.02
43 $448.21 $14.29 $433.92 $2,205.10
44 $448.21 $11.94 $436.27 $1,768.83
45 $448.21 $9.58 $438.63 $1,330.20
46 $448.21 $7.21 $441.01 $889.19
47 $448.21 $4.82 $443.40 $445.80
48 $448.21 $2.41 $445.80 $0.00

Written for

Course

Document information

Uploaded on
July 16, 2022
Number of pages
17
Written in
2021/2022
Type
Exam (elaborations)
Contains
Questions & answers

Subjects

$13.49
Get access to the full document:

Wrong document? Swap it for free Within 14 days of purchase and before downloading, you can choose a different document. You can simply spend the amount again.
Written by students who passed
Immediately available after payment
Read online or as PDF

Get to know the seller

Seller avatar
Reputation scores are based on the amount of documents a seller has sold for a fee and the reviews they have received for those documents. There are three levels: Bronze, Silver and Gold. The better the reputation, the more your can rely on the quality of the sellers work.
Classroom NURSING
Follow You need to be logged in order to follow users or courses
Sold
4875
Member since
4 year
Number of followers
3232
Documents
55418
Last sold
7 hours ago
NURSING

Assignments, Case Studies, Research, Essay writing service, Questions and Answers, Discussions etc. for students who want to see results twice as fast. I have done papers of various topics and complexities. I am punctual and always submit work on-deadline. I write engaging and informative content on all subjects. Send me your research papers, case studies, psychology papers, etc, and I’ll do them to the best of my abilities. Writing is my passion when it comes to academic work. I’ve got a good sense of structure and enjoy finding interesting ways to deliver information in any given paper. I love impressing clients with my work, and I am very punctual about deadlines. Send me your assignment and I’ll take it to the next level. I strive for my content to be of the highest quality. Your wishes come first— send me your requirements and I’ll make a piece of work with fresh ideas, consistent structure, and following the academic formatting rules. For every student you refer to me with an order that is completed and paid transparently, I will do one assignment for you, free of charge!!!!!!!!!!!!

Read more Read less
4.0

1185 reviews

5
624
4
216
3
196
2
40
1
109

Recently viewed by you

Why students choose Stuvia

Created by fellow students, verified by reviews

Quality you can trust: written by students who passed their tests and reviewed by others who've used these notes.

Didn't get what you expected? Choose another document

No worries! You can instantly pick a different document that better fits what you're looking for.

Pay as you like, start learning right away

No subscription, no commitments. Pay the way you're used to via credit card and download your PDF document instantly.

Student with book image

“Bought, downloaded, and aced it. It really can be that simple.”

Alisha Student

Working on your references?

Create accurate citations in APA, MLA and Harvard with our free citation generator.

Working on your references?

Frequently asked questions