A full amortization schedule for a note that is payed monthly (Interest and principle). The time...

A full amortization schedule for a note that is payed monthly (Interest and principle). The time frame is 5 years=60 months, the Interest Rate=5%, the Note is for $75,000.

Expert Solution

Loan Amount	Interest Rate	Term in Years	Monthly Payment
$75,000.00	5.00%	5	$1,415.34

Month	StartingBalance	Interest	Principal	EndingBalance	TotalInterest
1	$75,000.00	$312.50	$1,102.84	$73,897.16	$312.50
2	$73,897.16	$307.90	$1,107.44	$72,789.72	$620.40
3	$72,789.72	$303.29	$1,112.05	$71,677.67	$923.70
4	$71,677.67	$298.66	$1,116.69	$70,560.98	$1,222.35
5	$70,560.98	$294.00	$1,121.34	$69,439.64	$1,516.36
6	$69,439.64	$289.33	$1,126.01	$68,313.63	$1,805.69
7	$68,313.63	$284.64	$1,130.70	$67,182.93	$2,090.33
8	$67,182.93	$279.93	$1,135.41	$66,047.52	$2,370.26
9	$66,047.52	$275.20	$1,140.14	$64,907.37	$2,645.46
10	$64,907.37	$270.45	$1,144.90	$63,762.48	$2,915.90
11	$63,762.48	$265.68	$1,149.67	$62,612.81	$3,181.58
12	$62,612.81	$260.89	$1,154.46	$61,458.36	$3,442.47
13	$61,458.36	$256.08	$1,159.27	$60,299.09	$3,698.54
14	$60,299.09	$251.25	$1,164.10	$59,134.99	$3,949.79
15	$59,134.99	$246.40	$1,168.95	$57,966.05	$4,196.18
16	$57,966.05	$241.53	$1,173.82	$56,792.23	$4,437.71
17	$56,792.23	$236.63	$1,178.71	$55,613.52	$4,674.34
18	$55,613.52	$231.72	$1,183.62	$54,429.90	$4,906.07
19	$54,429.90	$226.79	$1,188.55	$53,241.35	$5,132.86
20	$53,241.35	$221.84	$1,193.50	$52,047.85	$5,354.70
21	$52,047.85	$216.87	$1,198.48	$50,849.37	$5,571.56
22	$50,849.37	$211.87	$1,203.47	$49,645.90	$5,783.44
23	$49,645.90	$206.86	$1,208.48	$48,437.42	$5,990.29
24	$48,437.42	$201.82	$1,213.52	$47,223.90	$6,192.12
25	$47,223.90	$196.77	$1,218.58	$46,005.32	$6,388.88
26	$46,005.32	$191.69	$1,223.65	$44,781.67	$6,580.57
27	$44,781.67	$186.59	$1,228.75	$43,552.91	$6,767.16
28	$43,552.91	$181.47	$1,233.87	$42,319.04	$6,948.63
29	$42,319.04	$176.33	$1,239.01	$41,080.03	$7,124.96
30	$41,080.03	$171.17	$1,244.18	$39,835.85	$7,296.13
31	$39,835.85	$165.98	$1,249.36	$38,586.49	$7,462.11
32	$38,586.49	$160.78	$1,254.57	$37,331.93	$7,622.89
33	$37,331.93	$155.55	$1,259.79	$36,072.13	$7,778.44
34	$36,072.13	$150.30	$1,265.04	$34,807.09	$7,928.74
35	$34,807.09	$145.03	$1,270.31	$33,536.78	$8,073.77
36	$33,536.78	$139.74	$1,275.61	$32,261.17	$8,213.50
37	$32,261.17	$134.42	$1,280.92	$30,980.25	$8,347.93
38	$30,980.25	$129.08	$1,286.26	$29,693.99	$8,477.01
39	$29,693.99	$123.72	$1,291.62	$28,402.38	$8,600.74
40	$28,402.38	$118.34	$1,297.00	$27,105.38	$8,719.08
41	$27,105.38	$112.94	$1,302.40	$25,802.97	$8,832.02
42	$25,802.97	$107.51	$1,307.83	$24,495.14	$8,939.53
43	$24,495.14	$102.06	$1,313.28	$23,181.86	$9,041.59
44	$23,181.86	$96.59	$1,318.75	$21,863.11	$9,138.18
45	$21,863.11	$91.10	$1,324.25	$20,538.87	$9,229.28
46	$20,538.87	$85.58	$1,329.76	$19,209.10	$9,314.86
47	$19,209.10	$80.04	$1,335.30	$17,873.80	$9,394.90
48	$17,873.80	$74.47	$1,340.87	$16,532.93	$9,469.37
49	$16,532.93	$68.89	$1,346.46	$15,186.47	$9,538.26
50	$15,186.47	$63.28	$1,352.07	$13,834.41	$9,601.54
51	$13,834.41	$57.64	$1,357.70	$12,476.71	$9,659.18
52	$12,476.71	$51.99	$1,363.36	$11,113.35	$9,711.17
53	$11,113.35	$46.31	$1,369.04	$9,744.32	$9,757.47
54	$9,744.32	$40.60	$1,374.74	$8,369.58	$9,798.07
55	$8,369.58	$34.87	$1,380.47	$6,989.11	$9,832.95
56	$6,989.11	$29.12	$1,386.22	$5,602.89	$9,862.07
57	$5,602.89	$23.35	$1,392.00	$4,210.89	$9,885.41
58	$4,210.89	$17.55	$1,397.80	$2,813.09	$9,902.96
59	$2,813.09	$11.72	$1,403.62	$1,409.47	$9,914.68
60	$1,409.47	$5.87	$1,409.47	$0.00	$9,920.55

WORKINGS

jeff jeffy answered 1 year ago

Prepare amortization schedule for the bond issuances. Note interest is semi- annual for the coupon bonds...

Prepare amortization schedule for the bond issuances. Note interest is semi- annual for the coupon bonds and you may assume annual for the zero- coupon bonds. ABC Co. issued $3,527 million face value, 20-year, zero coupon bonds on July 1, 2017 that mature June 30, 2037 for a cash price of $2,619 million. The effective market interest rate at issuance was 1.5%. Amounts shown in millions.

Finance- Amortization Schedule Create the amortization schedule for a loan of $5,000, paid monthly over two...

Finance- Amortization Schedule Create the amortization schedule for a loan of $5,000, paid monthly over two years using an 8 percent APR.

Prepare the amortization schedule for a thirty-year variable interest loan with monthly payments of $250,000 at...

Prepare the amortization schedule for a thirty-year variable interest loan with monthly payments of $250,000 at an APR of 6.8%.

a. Prepare the amortization schedule for a thirty-year variable interest loan with monthly payments of $250,000...

a. Prepare the amortization schedule for a thirty-year variable interest loan with monthly payments of $250,000 at an APR of 6.8%. specifies monthly compounding. b.What is the interest payment and principal amounts in the 110th payment? c. Use the annuity formula to find how much principal you still owe to the bank for the 110th payment. Check that this value is the same you have in your amortization schedule. d. How much in total interest will you pay? e. Suppose...

Problem 5-50 Amortization Schedule (LG9) Create the amortization schedule for a loan of $4,300, paid monthly...

Problem 5-50 Amortization Schedule (LG9) Create the amortization schedule for a loan of $4,300, paid monthly over two years using an 9 percent APR. (Round your answers to 2 decimal places.) Month Beginning Balance Total Payment Interest Paid Principal Paid Ending Balance 1 2 3 4 5 6 7 ...

Problem 5-49 Amortization Schedule (LG9) Create the amortization schedule for a loan of $14,000, paid monthly...

Problem 5-49 Amortization Schedule (LG9) Create the amortization schedule for a loan of $14,000, paid monthly over three years using a 9 percent APR. (Round your answers to 2 decimal places.) Month Beginning Balance Total Payment Interest Paid Principal Paid Ending Balance 1 2 3 4 5 6 7...

Amortization with Equal Payments. Prepare an amortization schedule for a three-year loan of $57,000. The interest...

Amortization with Equal Payments. Prepare an amortization schedule for a three-year loan of $57,000. The interest rate is 8 percent per year, and the loan calls for equal annual payments. How much interest is paid in the third year? How much total interest is paid over the life of the loan?

Amortization Schedule You will be creating an amortization schedule for a house on the market. To...

Amortization Schedule You will be creating an amortization schedule for a house on the market. To do so, you will need the principal amount, the interest rate, and the amount of years you will borrow the loan. The amount you put as a down payment is up to you, but it can range from a minimum of 3.5% for an FHA loan or 5% for a traditional loan to a maximum of whatever. Traditionally you only need to go as...

Prepare an amortization schedule (monthly) for a 30yr mortgage on a building that costs $280,000. 20%...

Prepare an amortization schedule (monthly) for a 30yr mortgage on a building that costs $280,000. 20% down was required to get at an APR of 5%, the rest of the cost was financed. Compare the principle balance and the interest in the first, second, fifth, tenth, twentieth, and thirtieth year. Now prepare an amortization schedule for a 20yr mortgage on the same building. Compare the principle balance and interest in the same years as you did in the 30yr mortgage.

AMORTIZATION SCHEDULE a. Complete an amortization schedule for a $25,000 loan to be repaid in equal...

AMORTIZATION SCHEDULE a. Complete an amortization schedule for a $25,000 loan to be repaid in equal installments at the end of each of the next three years. The interest rate is 8% compounded annually. Round all answers to the nearest cent. Beginning Repayment Ending Year Balance Payment Interest of Principal Balance 1 $ $ $ $ $ 2 3 b. What percentage of the payment represents interest and what percentage represents principal for each of the three years? Round all...

Question