Question: USING A LOAN AMORTIZATION TABLE . You has just borrowed $5,000 on a four year loan at 8% simple amortized interest.Complete the Amortization table below

USING A LOAN AMORTIZATION TABLE. You has just borrowed $5,000 on a four year loan at 8% simple amortized interest.Complete the Amortization table below for the first 6 month of the loan.

Applied Applied Payment Beginning Payment to to New Number Balance amount interest Principal Balance $5,000.00 $122 $33.33 $88.67 $4,911.33 2 A $122 $32.74 B $4.822.07 3 $4,822.00 $122 C $89.85 $4,732.22 4 $4,732.22 $122 D $90.45 E 5 $4.641.77 $122 30.95 F $4550.72 $4550.72 G HI

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

15) USING A LOAN AMORTIZATION TABLE. You has just borrowed $80,000 on a 10 year loan at 7.75% simple amortized interest. Create a Loan Amortization table below for the first 6 month of the loan

16) USING A LOAN AMORTIZATION TABLE. You has just borrowed $5,000 on a four year loan at 8% simple amortized interest. Complete the Amortization table below for the first 6 month of the loan

16) USING A LOAN AMORTIZATION TABLE. You has just borrowed $5,000 on a four year loan at 8% simple amortized interest. Complete the Amortization table below for the first 6 month of the loan. Applied...

HERE IS SOME EXAMPLES AND RULES : 4. Use the Excel formulas discussed in the example in class. For example, for month # 1 in the reference amortization table given above, the formulas used are:...

Listen to the following videos and then complete the assignments using the changed numbers on the guidance report. Place your answers on the guidance report. Open the Guidance Report and rework the...

Can someone help me with this? I need it by tomorrow chapter 2 Issues in Accounting for Corporate Debt and Equity istockphoto Learning Objectives Be able to articulate the advantages and...

Why is primus Automation considering the lease of its factory-automation system to Avantjet? How did Tom Baumann analyze the problem of setting the lease-financing terms? How does the calculate NPV...

Citywide Company Issues bonds with a parvalue of $70,000 on thelr stated issue date. The bonds mature In eight years and pay 10% annual interest in semiannual payments. On the ssue date, the annual...

Question 5. HINDSIGHT, THEY SAY IS 20/20, So, in retrospect, it is not so surprising that the born in real estate prices of just a few years ago was followed by a painful collapse. Fueled in part by...

Please follow the special instructions , DONT SOLVE C! please show formulas used . Chegg does not take excel pdfs so upload a screenshot or picture of the answer. ONLY SOLVE A & B 14-12. A loan...

Consider a band gap diagram of simple LED. Assume all recombination as direct & result in light emision, A. F.B. is applied on the junction. A B ET m Polev 017ev B 017ev Ec EF (a) In which region...

Suppose an internet has the organization shown in Figure, with software using the given transport layer addresses and machines using the given data link layer addresses. a. List the network layer...

Market value ( market capitalization ) is defined as share price times the number of shares outstanding share price times the number of issued shares share price times the number of held by the...

8) An investment will pay $100 at the end of each year for 20 years, and on the date of the last payment will also make a separate payment of $1,000. If your required rate of return on this...