The credit plan at TidBit Computer Store specifies a 10% down payment and an annual interest rate of 12%. Monthly payments are 5% of the listed purchase price, minus the down payment. Write a program that takes the purchase price as input. The program should display a table, with appropriate headers, of a payment schedule for the lifetime of the loan. Each row of the table should contain the following items:

COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
1st Edition
ISBN:9780357392676
Author:FREUND, Steven
Publisher:FREUND, Steven
Chapter4: Financial Functions, Data Tables, And Amortization Schedules
Section: Chapter Questions
Problem 3EYW
icon
Related questions
Question

The credit plan at TidBit Computer Store specifies a 10% down payment and an annual interest rate of 12%. Monthly payments are 5% of the listed purchase price, minus the down payment.

Write a program that takes the purchase price as input. The program should display a table, with appropriate headers, of a payment schedule for the lifetime of the loan. Each row of the table should contain the following items:

  1. The month number (beginning with 1)
  2. The current total balance owed
  3. The interest owed for that month
  4. The amount of principal owed for that month
  5. The payment for that month
  6. The balance remaining after payment

The amount of interest for a month is equal to balance × rate / 12.

The amount of principal for a month is equal to the monthly payment minus the interest owed.

Enter the puchase price: 200
Month Starting Balance Interest to Pay Principal to Pay Payment Ending B:
1
180.00
1.80
7.20
9.00
2
172.80
1.73
7.27
9.00
3
165.53
1.66
7.34
9.00
4
158.18
1.58
7.42
9.00
150.77
1.51
7.49
9.00
143.27
1.43
7.57
9.00
7
135.71
1.36
7.64
9.00
8.
128.06
1.28
7.72
9.00
9
120.34
1.20
7.80
9.00
10
112.55
1.13
7.87
9.00
11
104.67
1.05
7.95
9.00
12
96.72
0.97
8.03
9.00
1
13
88.69
0.89
8.11
9.00
14
80.57
0.81
8.19
9.00
15
72.38
0.72
8.28
9.00
16
64.10
0.64
8.36
9.00
17
55.74
0.56
8.44
9.00
18
47.30
0.47
8.53
9.00
19
38.77
0.39
8.61
9.00
20
30.16
0.30
8.70
9.00
21
21.46
0.21
8.79
9.00
22
12.68
0.13
8.87
9.00
23
3.80
0.00
3.80
3.80
NNN N N N
Transcribed Image Text:Enter the puchase price: 200 Month Starting Balance Interest to Pay Principal to Pay Payment Ending B: 1 180.00 1.80 7.20 9.00 2 172.80 1.73 7.27 9.00 3 165.53 1.66 7.34 9.00 4 158.18 1.58 7.42 9.00 150.77 1.51 7.49 9.00 143.27 1.43 7.57 9.00 7 135.71 1.36 7.64 9.00 8. 128.06 1.28 7.72 9.00 9 120.34 1.20 7.80 9.00 10 112.55 1.13 7.87 9.00 11 104.67 1.05 7.95 9.00 12 96.72 0.97 8.03 9.00 1 13 88.69 0.89 8.11 9.00 14 80.57 0.81 8.19 9.00 15 72.38 0.72 8.28 9.00 16 64.10 0.64 8.36 9.00 17 55.74 0.56 8.44 9.00 18 47.30 0.47 8.53 9.00 19 38.77 0.39 8.61 9.00 20 30.16 0.30 8.70 9.00 21 21.46 0.21 8.79 9.00 22 12.68 0.13 8.87 9.00 23 3.80 0.00 3.80 3.80 NNN N N N
Expert Solution
Step 1

Given :- 

The credit plan at TidBit Computer Store specifies a 10% down payment and an annual interest rate of 12%. Monthly payments are 5% of the listed purchase price, minus the down payment.

Write a program that takes the purchase price as input. The program should display a table, with appropriate headers, of a payment schedule for the lifetime of the loan. Each row of the table should contain the following items:

  1. The month number (beginning with 1)
  2. The current total balance owed
  3. The interest owed for that month
  4. The amount of principal owed for that month
  5. The payment for that month
  6. The balance remaining after payment

The amount of interest for a month is equal to balance × rate / 12.

The amount of principal for a month is equal to the monthly payment minus the interest owed.

trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 1 images

Blurred answer
Knowledge Booster
Graphical User Interface
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:
9780357392676
Author:
FREUND, Steven
Publisher:
CENGAGE L
Np Ms Office 365/Excel 2016 I Ntermed
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
Operations Research : Applications and Algorithms
Operations Research : Applications and Algorithms
Computer Science
ISBN:
9780534380588
Author:
Wayne L. Winston
Publisher:
Brooks Cole