Business, 25.07.2020 21:01 jordaaan101

Corey buys 10 Tuff lift 4-post, 4.5-ton car hoists for his parking garage at a total cost of $410,000. He finances this with a five-year loan at 6.2% APR with monthly payments. After he has made the first 20 payments, how much is the outstanding principal balance on his loan

Answers: 1

Show answers

Answers

Answer from: snikergrace

$291,707

Explanation:

Here first we need to determine the monthly payments using the "PMT" function in excel. The inputs are: rate = 7%/12, nper = 5 years*12 = 60 and PV = 414,000

Thus PMT(7%/12, 60, 414000) = $8,197.70

Now let's make a loan amortization table as shown below:

Month Loan left Monthly Interest Principal Loan balan

at the start payment at the end

of the month of the month.

1.414,000.008,197.70 2,415.00 5,782.70 408,217

2. 408,217.308,197.70 2,381.27 5,816.43 402,401

3. 402,400.888,197.70 2,347.34 5,850.36 396,551

4.396,550.528,197.70 2,313.21 5,884.48 390,666

5.390,666.038,197.70 2,278.89 5,918.81 384,747

6.384,747.228,197.70 2,244.36 5,953.34 378,794

7.378,793.888,197.70 2,209.63 5,988.07 372,806

8.372,805.828,197.70 2,174.70 6,023.00 366,783

9. 366,782.828,197.70 2,139.57 6,058.13 360,725

10.360,724.698,197.70 2,104.23 6,093.47 354,631 11.354,631.228,197.70 2,068.68 6,129.01 348,502

12. 348,502.218,197.70 2,032.93 6,164.77 342,337

13. 342,337.448,197.70 1,996.97 6,200.73 336,137

14. 336,136.728,197.70 1,960.80 6,236.90 329,900

15. 329,899.828,197.70 1,924.42 6,273.28 323,627

16. 323,626.548,197.70 1,887.82 6,309.87 317,317

17. 317,316.668,197.70 1,851.01 6,346.68 310,970

18. 310,969.988,197.70 1,813.99 6,383.70 304,586

19. 304,586.288,197.70 1,776.75 6,420.94 298,165

20. 298,165.338,197.70 1,739.30 6,458.40 291,707

Answer from: Quest

im going to come back to you?

Answer from: Quest

It would be option a

Another question on Business

Business, 21.06.2019 20:30

As a group is leaving, you ask them if they had a good experience at the restaurant. they mention that they had poor service and their food was cold. a.apologize and ask them to give the restaurant another chance in the future. you tell them that guests usually have a great experience here. b.apologize then ask for the server’s name and immediately notify the manager after they leave. c.apologize for the bad experience and ask them to wait as you call the manager to talk to them. d.apologize for the bad experience and encourage them to complete the customer service survey. this feedback will ensure other guests do not have the same experience.

Answers: 2

Answer

Business, 22.06.2019 17:50

What additional information about the numbers used to compute this ratio might be useful in you assess liquidity? (select all that apply) (a) the maturity schedule of current liabilities (b) the average stock price for the industry (c) the average current ratio for the industry (d) the amount of current assets that is concentrated in relatively illiquid inventories

Answers: 3

Answer

Business, 22.06.2019 18:00

If you would like to ask a question you will have to spend some points

Answers: 1

Answer

Business, 22.06.2019 19:30

Quick calculate the roi dollar amount and percentage for these example investments. a. you invest $50 in a government bond that says you can redeem it a year later for $55. use the instructions in lesson 3 to calculate the roi dollar amount and percentage. (3.0 points) tip: subtract the initial investment from the total return to get the roi dollar amount. then divide the roi dollar amount by the initial investment, and multiply that number by 100 to get the percentage. b. you invest $200 in stocks and sell them one year later for $230. use the instructions in lesson 3 to calculate the roi dollar amount and percentage. (3.0 points) tip: subtract the initial investment from the total return to get the roi dollar amount. then divide the roi dollar amount by the initial investment, and multiply that number by 100 to get the percentage.

Answers: 2

Answer

You know the right answer?

Corey buys 10 Tuff lift 4-post, 4.5-ton car hoists for his parking garage at a total cost of $410,00...

Questions