Business, 19.03.2020 06:59, ktene993

A fully amortizing mortgage loan is made for $80,000 at 6 percent interest for 25 years. Payments are to be made monthly. Calculate: a. Monthly payments. b. Interest and principal payments during month 1. c. Total principal and total interest paid over 25 years. d. The outstanding loan balance if the loan is repaid at the end of year 10. e. Total monthly interest and principal payments through year 10. f. What would the breakdown of interest and principal be during month 50

Answers: 3

Show answers

Answers

answered: jude40

Explanation:

We would use an online amortization calculator to solve this question.

Loan Amount = 80,000

Term = 25 years

Interest Rate = 6 %

We would plug in these values into the mortgage calculator

https://www.amortization-calc.com/mortgage-calculator/

A - Monthly payments = $515.44

B - Interest paid in month1 = $400

Principle paid in month1 = $115

C - Total principle paid over 25 years = $80,000

Total interest paid over the 25 years = $74,632

D - The outstanding loan balance at the end of year10 $61,082

E - Total principal payments through year10 = $18918

Total interest payments through year10 = $42,935

F - Interest = $368

Principle = $147

answered: hardwick744

a. Monthly payments.

Number of payments= 25 × 12 = 300

Monthly Interest rateI=6%/12=0.5%

PV = $80,000

FV = 0

Using PMT formula in excel to calculate:

PMT = 515.44

Monthly payment is $515.44.

b. Interest and principal payments during month 1.

Interest payment during month 1 is $80,000 × 0.5%= 400

Principal payment during month 1 is $ 515.44 - $ 400 = $115.44

c. Total principal and total interest paid over 25 years.

Total principal payment is $ 80,000

Total interest payment is total payments – total principal payment =

(515.44 × 300) - $ 80,000 = $ 74,632 .

d. The outstanding loan balance if the loan is repaid at the end of year 10.

Number of payments = 10 × 12 = 120

I= 0.5%

PV = - $80,000

PMT = $515.44

Using PMT formula in excel to calculate the FV.

FV = 61,081.77

e. Total monthly interest and principal payments through year 10.

Total payment through year 10 is $515.44 × 120 = $61,852.8

Total principal payment is 80,000 – 61,081.77 = $18,918.23

Total interest payment is $61,852.8 - $18,918.23 = 42,934.57

f. What would the breakdown of interest and principal be during month 50

Loan balance at the end of month 49

Number of payments = 49

I=0.5%

PV = - $80,000

PMT = $515.44

Using PMT formula in excel to calculate the FV.

FV = 73,608.28

Interest payment is $73,608.28 × 0.5% = $368.04

Principal payment is 515.44 – 368.04 = $ 147.40

answered: Guest

b, fewer problems later! good luck

answered: Guest

Let me socratic give a few mins

Other questions on the subject: Business

Business, 22.06.2019 06:10, PLEASEHELP4528

P11.2a (lo 2, 4) fechter corporation had the following stockholders’ equity accounts on january 1, 2020: common stock ($5 par) $500,000, paid-in capital in excess of par—common stock $200,000, and retained earnings $100,000. in 2020, the company had the following treasury stock transactions. journalize and post treasury stock transactions, and prepare stockholders’ equity section. mar. 1 purchased 5,000 shares at $8 per share. june 1 sold 1,000 shares at $12 per share. sept. 1 sold 2,000 shares at $10 per share. dec. 1 sold 1,000 shares at $7 per share. fechter corporation uses the cost method of accounting for treasury stock. in 2020, the company reported net income of $30,000. instructions a. journalize the treasury stock transactions, and prepare the closing entry at december 31, 2020, for net income. b. open accounts for (1) paid-in capital from treasury stock, (2) treasury stock, and (3) retained earnings. (post to t-accounts.) c. prepare the stockholders’ equity section for fechter corporation at december 31, 2020.

Answers: 1

continue

Business, 22.06.2019 08:00, maddison788

Shrieves casting company is considering adding a new line to its product mix, and the capital budgeting analysis is being conducted by sidney johnson, a recently graduated mba. the production line would be set up in unused space in the main plant. the machinery’s invoice price would be approximately $200,000, another $10,000 in shipping charges would be required, and it would cost an additional $30,000 to install the equipment. the machinery has an economic life of 4 years, and shrieves has obtained a special tax ruling that places the equipment in the macrs 3-year class. the machinery is expected to have a salvage value of $25,000 after 4 years of use. the new line would generate incremental sales of 1,250 units per year for 4 years at an incremental cost of $100 per unit in the first year, excluding depreciation. each unit can be sold for $200 in the first year. the sales price and cost are both expected to increase by 3% per year due to inflation. further, to handle the new line, the firm’s net working capital would have to increase by an amount equal to 12% of sales revenues. the firm’s tax rate is 40%, and its overall weighted average cost of capital, which is the risk-adjusted cost of capital for an average project (r), is 10%. define “incremental cash flow.” (1) should you subtract interest expense or dividends when calculating project cash flow?

Answers: 1

continue

Business, 22.06.2019 11:10, evansh78

Use the following account numbers and corresponding account titles to answer the following question. account no. account title (1) cash (2) merchandise inventory (3) cost of goods sold (4) transportation-out (5) dividends (6) common stock (7) selling expense (8) loss on the sale of land (9) sales which accounts would appear on the income statement?

Answers: 3

continue

Business, 22.06.2019 17:00, ocean11618

Oliver is the vice president of production at his company and has been managing the launch of new software systems. he worked with a team of individuals who were tasked to create awareness about a specific product and also to approach potential purchasers of the product. which department managers were part of oliver’s team?

Answers: 3

continue

Do you know the correct answer?

A fully amortizing mortgage loan is made for $80,000 at 6 percent interest for 25 years. Payments ar...