Question

In: Accounting

Visionary Products purchased a building for $1,000,000 with 20% cash down payment and the remainder paid...

Visionary Products purchased a building for $1,000,000 with 20% cash down payment and the remainder paid in installments with 3% interest. Using excel, prepare an amortization schedule for the mortgage. I guess its okay to assume 30 year.

Solutions

Expert Solution

cost of building

Year

1000000

amount of loan

1000000*(1-.2)

800000

Period

It is assumed annual payment

30 Years

interest rate

3%

Yearly payment = Using PMT function in MS excel

PMT(rate,nper,pv,fv,type) =pmt(3%,30,800000,0,0)

($40,815.41)

Year

Balance due at the beginning

Yearly payment

Amount of interest

amount of principal

balance at year end

0

800000

1

800000

40815.41

24000

16815.41

783184.6

2

783184.6

40815.41

23495.54

17319.87

765864.7

3

765864.7

40815.41

22975.94

17839.47

748025.2

4

748025.2

40815.41

22440.76

18374.65

729650.6

5

729650.6

40815.41

21889.52

18925.89

710724.7

6

710724.7

40815.41

21321.74

19493.67

691231

7

691231

40815.41

20736.93

20078.48

671152.6

8

671152.6

40815.41

20134.58

20680.83

650471.7

9

650471.7

40815.41

19514.15

21301.26

629170.5

10

629170.5

40815.41

18875.11

21940.3

607230.2

11

607230.2

40815.41

18216.91

22598.5

584631.7

12

584631.7

40815.41

17538.95

23276.46

561355.2

13

561355.2

40815.41

16840.66

23974.75

537380.5

14

537380.5

40815.41

16121.41

24694

512686.5

15

512686.5

40815.41

15380.59

25434.82

487251.6

16

487251.6

40815.41

14617.55

26197.86

461053.8

17

461053.8

40815.41

13831.61

26983.8

434070

18

434070

40815.41

13022.1

27793.31

406276.7

19

406276.7

40815.41

12188.3

28627.11

377649.6

20

377649.6

40815.41

11329.49

29485.92

348163.6

21

348163.6

40815.41

10444.91

30370.5

317793.1

22

317793.1

40815.41

9533.794

31281.62

286511.5

23

286511.5

40815.41

8595.346

32220.06

254291.5

24

254291.5

40815.41

7628.744

33186.67

221104.8

25

221104.8

40815.41

6633.144

34182.27

186922.5

26

186922.5

40815.41

5607.676

35207.73

151714.8

27

151714.8

40815.41

4551.444

36263.97

115450.8

28

115450.8

40815.41

3463.525

37351.89

78098.94

29

78098.94

40815.41

2342.968

38472.44

39626.49

30

39626.49

40815.41

1188.795

39626.62

0

ekkarill92 answered 2 years ago
Next > < Previous

Related Solutions

he purchase of a building with a cash down payment and a written promise to pay...
he purchase of a building with a cash down payment and a written promise to pay the balance in the future would include​ a: A. debit to Cash and a credit to Buildings B. debit to Cash and a debit to Note Payable C. debit to Note Payable and a credit to Cash D. credit to Cash and a credit to Note Payable
The McDonald Group purchased a piece of property for $1.5 million. It paid a down payment...
The McDonald Group purchased a piece of property for $1.5 million. It paid a down payment of 20% in cash and financed the balance. The loan terms require monthly payments for 15 years at an annual percentage rate of 5% compounded monthly. 1. What is the amount of each mortgage payment? 2. What is the loan balance at the end of year 5? 3. What is the amount of interest that needs to be repaid during year 5?
The McDonald Group purchased a piece of property for $1.5 million. It paid a down payment...
The McDonald Group purchased a piece of property for $1.5 million. It paid a down payment of 20% in cash and financed the balance. The loan terms require monthly payments for 15 years at an annual percentage rate of 5% compounded monthly. -What is the amount of each mortgage payment? -What is the loan balance at the end of year 5? -What is the amount of principal that needs to repaid during year 5? -What is the amount of interest...
You financed the purchase of a $300,000 apartment with a down payment in cash of 20%...
You financed the purchase of a $300,000 apartment with a down payment in cash of 20% of the purchase price. The remaining 80% is financed with a mortgage with a 1% monthly interest rate over the next 20 years. The mortgage is repaid with equal monthly installments. Compute the monthly installments on the mortgage. (5 points) What is the outstanding principal balance of the mortgage after 5 years (i.e., after 60 installments)? (5 points) Ten years later (after 120 installments),...
You just purchased a $400,000 house and gave a 20% down payment. For the remaining portion,...
You just purchased a $400,000 house and gave a 20% down payment. For the remaining portion, you obtained a 30-year mortgage at a 6% interest rate. (6 points) What are the monthly payments on this mortgage? If the house appreciates at a 3 percent annually, what will be the value of the house in ten years? In ten years, how much equity will you have on this home? Answer all questions and show work in Excel. SHOW ME IN EXCEL...
Fifteen years ago a couple purchased a house for $230,000.00 by paying a 20% down payment...
Fifteen years ago a couple purchased a house for $230,000.00 by paying a 20% down payment and financing the remaining balance with a 30-year mortgage at 4.7% compounded monthly. (a) Find the monthly payment for this loan. (b) Find the balance of the loan after 16 years and after 17 years? (c) Find the total amount of interest paid by the couple during the 17th year.
Sam purchased a 2020 PT Cruiser GT for $25,000. Sam paid a 5%down payment, and...
Sam purchased a 2020 PT Cruiser GT for $25,000. Sam paid a 5% down payment, and then obtained a 60-month installment loan with an APR of 8%. a. Determine the amount of the down payment. b. Determine Sam’s total finance charge.a. Determine the amount of the down payment.b. Determine Sam’s total finance charge.
Purchased land and building for $260,000 as follows: $60,000 paid in cash and a 12% note...
Purchased land and building for $260,000 as follows: $60,000 paid in cash and a 12% note payable due 12/1/19 was signed for $200,000. The land value was $20,000 and the building value was $240,000 The building has a 30-year useful life and no salvage value. The company uses straight line depreciation. How is this posted on the General Journal sheet?
Prudence Corporation purchased a machine for $460,000 on September 1, 2019, by paying 20% down payment...
Prudence Corporation purchased a machine for $460,000 on September 1, 2019, by paying 20% down payment in cash and for the balance amount signed a 6%, 10-month note payable for the balance amount. Interest and principle will be paid back together at the end of the note. Prepare journal entries to record: the purchase of the delivery truck, the adjusting journal entry to record the accrued interest on December 31, and the payment of the note at maturity along with...
A couple has just purchased a home for $312,100.00. They will pay 20% down in cash,...
A couple has just purchased a home for $312,100.00. They will pay 20% down in cash, and finance the remaining balance. The mortgage broker has gotten them a mortgage rate of 5.64% APR with monthly compounding. The mortgage has a term of 30 years. How much interest is paid on the first payment? A couple has just purchased a home for $312,100.00. They will pay 20% down in cash, and finance the remaining balance. The mortgage broker has gotten them...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT