Loan (PV) Annual Rate Payments per Year Rate per Period (RATE) Years Payments (NPER) $375,000 6.50% 4 5...
| Loan (PV) | Annual Rate | Payments per Year | Rate per Period (RATE) | Years |
Payments (NPER) |
| $375,000 | 6.50% | 4 | 5 | 30 | |
| Amortization Schedule | |||||
| Year | Period |
Remaining Principal |
Interest Payment |
Principal Payment |
Total Payment |
| 1 | 1 | ||||
| 1 | 2 | ||||
| 1 | 3 | ||||
| 1 | 4 | ||||
| 2 | 5 | ||||
| 2 | 6 | ||||
| 2 | 7 | ||||
| 2 | 8 | ||||
| 3 | 9 | ||||
| 3 | 10 | ||||
| 3 | 11 | ||||
| 3 | 12 | ||||
| 4 | 13 | ||||
| 4 | 14 | ||||
| 4 | 15 | ||||
| 4 | 16 | ||||
| 5 | 17 | ||||
| 5 | 18 | ||||
| 5 | 19 | ||||
| 5 | 20 | ||||
| Final Balance | |||||
Need help on finishing in the blank squares.
Homework Answers
Rate per period = 1.625%
The payment for each quarter is calculated as follows:-
Payment for each quarter = $22,112.24
-------------------------------------------------------------------------------------------------------------------
Total payment = $22,112.24
Interest payment of a period = 1.625% x Remaining principal of previous period
Principal payment = Total payment - interest payment
Remaining principal = Remaining principal of previous period - Principal payment of the period
| Loan (PV) | Annual Rate | Payments per Year | Rate per Period (RATE) % | Years | Payments |
| (NPER) | |||||
| $375,000 | 6.50% | 4 | 1.625 | 5 | 30 |
| Year | Period | Remaining | Interest | Principal | Total Payment |
| Principal | Payment | Payment | |||
| 1 | 1 | $358,981.51 | $6,093.75 | $16,018.49 | $22,112.24 |
| 1 | 2 | $342,702.72 | $5,833.45 | $16,278.79 | $22,112.24 |
| 1 | 3 | $326,159.40 | $5,568.92 | $16,543.32 | $22,112.24 |
| 1 | 4 | $309,347.25 | $5,300.09 | $16,812.15 | $22,112.24 |
| 2 | 5 | $292,261.90 | $5,026.89 | $17,085.35 | $22,112.24 |
| 2 | 6 | $274,898.92 | $4,749.26 | $17,362.98 | $22,112.24 |
| 2 | 7 | $257,253.79 | $4,467.11 | $17,645.13 | $22,112.24 |
| 2 | 8 | $239,321.92 | $4,180.37 | $17,931.87 | $22,112.24 |
| 3 | 9 | $221,098.66 | $3,888.98 | $18,223.26 | $22,112.24 |
| 3 | 10 | $202,579.27 | $3,592.85 | $18,519.39 | $22,112.24 |
| 3 | 11 | $183,758.95 | $3,291.91 | $18,820.33 | $22,112.24 |
| 3 | 12 | $164,632.79 | $2,986.08 | $19,126.16 | $22,112.24 |
| 4 | 13 | $145,195.83 | $2,675.28 | $19,436.96 | $22,112.24 |
| 4 | 14 | $125,443.02 | $2,359.43 | $19,752.81 | $22,112.24 |
| 4 | 15 | $105,369.23 | $2,038.45 | $20,073.79 | $22,112.24 |
| 4 | 16 | $84,969.24 | $1,712.25 | $20,399.99 | $22,112.24 |
| 5 | 17 | $64,237.75 | $1,380.75 | $20,731.49 | $22,112.24 |
| 5 | 18 | $43,169.38 | $1,043.86 | $21,068.38 | $22,112.24 |
| 5 | 19 | $21,758.64 | $701.50 | $21,410.74 | $22,112.24 |
| 5 | 20 | $0.00 | $353.58 | $21,758.66 | $22,112.24 |
| Final Balance | $0 |
Add Answer to:
Loan (PV) Annual Rate Payments per Year Rate per Period (RATE) Years Payments (NPER) $375,000 6.50% 4 5...
Construct an amortization schedule for a $1,000, 10% annual rate loan with 3 equal annual payments....
Construct an amortization schedule for a $1,000, 10% annual rate loan with 3 equal annual payments. Step #1: Find the required annual payment on the loan. Step #2: Complete the amortization table for the loan. (4) = (2)-(3) (5) = (1)-(4) (3) = (1) * interest rate INTEREST EXPENSE PAYMENT YEAR PERIOD BEGINNING BALANCE PRINCIPAL REPAYMENT ENDING BALANCE
Loan amortization schedule Personal Finance Problem Joan Messineo borrowed $46,000 at a 4% annual rate of...
Loan amortization schedule Personal Finance Problem Joan Messineo borrowed $46,000 at a 4% annual rate of interest to be repaid over 3 years. The loan is amortized into three equal, annual end-of-year payments Calculate the annual end of year loan payment b. Prepare a loan amortization schedule showing the interest and principal breakdown of each of the three loan payments. c. Explain why the interest portion of each payment declines with the passage of time. a. The amount of the...
Melissa received a loan of $9,000 at 6.50% compounded quarterly. She had to make payments at...
Melissa received a loan of $9,000 at 6.50% compounded quarterly. She had to make payments at the end of every quarter for a period of 1 year to settle the loan. a. Calculate the size of payments. Round to the nearest cent b. Fill in the amortization schedule, rounding the answers to two decimal places. Amount Paid Payment Number Interest Portion Principal Portion Principal Balance $9,000.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00...
A $100,000 loan requires equal annual end-of-year payments of $38,803.35 for three years. a. What is...
A $100,000 loan requires equal annual end-of-year payments of $38,803.35 for three years. a. What is the annual interest rate? b. Construct a loan amortization schedule to include the amount of interest and principal paid each year as well as the remaining balance at the end of each year. Enter the last principal number in year 3: for example in problem 13: you would enter 5735.84 (which was the last principal for 4 years).
Crab State Bank has offered you a $500,000 5-year loan at an interest rate of 9.25...
Crab State Bank has offered you a $500,000 5-year loan at an interest rate of 9.25 percent, requiring equal annual end-of-year payments that include both principal and interest on the unpaid balance. Develop an amortization schedule for this loan. Round your answers to the nearest dollar. Do not round intermediate calculations. End of Year Payment Interest (9.25%) Principal Reduction Balance Remaining 0 - - - $500,000 1 $ $ $ 2 3 ...
repare an amortization schedule for a five-year loan of $45,000. The interest rate is 8% per...
repare an amortization schedule for a five-year loan of $45,000. The interest rate is 8% per year, and the loan calls for equal annual payments. (Do not round intermediate calculations. Enter all amount as positive value. Round the final answers to 2 decimal places. Leave no cells blank - be certain to enter "0" wherever required.) Year Beginning Balance Total Payment Interest Payment Principal Payment Ending Balance 1 $ $ $ $ $ 2 3 4 5 How much interest...
A loan of 100,000 is to be repaid in 4 level annual payments starting one year...
A loan of 100,000 is to be repaid in 4 level annual payments starting one year after the loan date. For the first 2 years, the annual interest rate is 8%; for the last 2 years, the annual interest rate is 4%. Find the annual payment and complete the loan amortization table. t Payment Interest Due Principal Repaid Outstanding Balance 0 100,000 1 2 3 4
aSuppose you bought a house and took out a mortgage for $100,000. The interest rate is...
aSuppose you bought a house and took out a mortgage for $100,000. The interest rate is 3%, and you must amortize the loan over 10 years with equal end-of-year payments. A. Calculate the mortgage payment using the Excel function Rate Nper PV FV Payment B. Set up an amortization schedule that shows the annual payments and the amount of each payment that repays the principal and the amount that constitutes interest expense to the borrower and interest income to the...
Prepare an amortization schedule for a five-year loan of $33,000. The interest rate is 9% per...
Prepare an amortization schedule for a five-year loan of $33,000. The interest rate is 9% per year, and the loan calls for equal annual payments. (Do not round intermediate calculations. Enter all amount as positive value. Round the final answers to 2 decimal places. Leave no cells blank - be certain to enter "0" wherever required.) Beginning Balance $ Total Payment $ Interest Payment $ Principal Payment $ Year Ending Balance $ 2 3 4 5 How much interest is...
Solve all of the following problems with Excel. Please use formulas in excel to solve. (2) (a) Assume monthly car payments of $500 per month for 4 years and an interest rate of 0.75% per month. 1. Wha...
Solve all of the following problems with Excel. Please use formulas in excel to solve. (2) (a) Assume monthly car payments of $500 per month for 4 years and an interest rate of 0.75% per month. 1. What initial principal will this repay? (b) Assume annual car payments of $6000 for 4 years and an interest rate of 9% per year. 1. What initial principal will this repay? (c) Assume monthly car payments of $500 per month for 4 years...
Construct an amortization schedule for a $1,000, 10% annual rate loan with 3 equal annual payments. Step #1: Find the required annual payment on the loan. Step #2: Complete the amortization table for the loan. (4) = (2)-(3) (5) = (1)-(4) (3) = (1) * interest rate INTEREST EXPENSE PAYMENT YEAR PERIOD BEGINNING BALANCE PRINCIPAL REPAYMENT ENDING BALANCE
Loan amortization schedule Personal Finance Problem Joan Messineo borrowed $46,000 at a 4% annual rate of interest to be repaid over 3 years. The loan is amortized into three equal, annual end-of-year payments Calculate the annual end of year loan payment b. Prepare a loan amortization schedule showing the interest and principal breakdown of each of the three loan payments. c. Explain why the interest portion of each payment declines with the passage of time. a. The amount of the...
Melissa received a loan of $9,000 at 6.50% compounded quarterly. She had to make payments at the end of every quarter for a period of 1 year to settle the loan. a. Calculate the size of payments. Round to the nearest cent b. Fill in the amortization schedule, rounding the answers to two decimal places. Amount Paid Payment Number Interest Portion Principal Portion Principal Balance $9,000.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00...
Prepare an amortization schedule for a five-year loan of $33,000. The interest rate is 9% per year, and the loan calls for equal annual payments. (Do not round intermediate calculations. Enter all amount as positive value. Round the final answers to 2 decimal places. Leave no cells blank - be certain to enter "0" wherever required.) Beginning Balance $ Total Payment $ Interest Payment $ Principal Payment $ Year Ending Balance $ 2 3 4 5 How much interest is...
Most questions answered within 3 hours.
-
What are five tips in conducting knowledge assessment/literature
review research? Each of these tips needs to...
asked 32 minutes ago -
Antigen presenting cells link innate and adaptive immune
responses. In the theoretical scenario where phagosomes cannot...
asked 38 minutes ago -
Dealing with conflict, in my opinion, is a skill and an art. I
believe that those...
asked 1 hour ago -
6. A long straight wire with circular cross section and radius
1.5 cm carries a 1.2...
asked 1 hour ago -
Deacon Corporation has provided the following financial data
from its balance sheet and income statement:
Year...
asked 2 hours ago -
List and discuss at least three variables from everyday life for
which you expect the variable ...
asked 2 hours ago -
A high-pass filter consists of a 1.60 μF capacitor in series
with a 125 Ω resistor....
asked 2 hours ago -
A newly developed artificial intelligence has trouble
distinguishing hand-written numbers from hand-written alphabets.
There are pictures...
asked 2 hours ago -
The carbonate ion CO3 2- has multiple resonance structures.
a. Draw them and assign the hybridization...
asked 2 hours ago -
In doing an allocation for a basket purchase
Use the individual costs and the total market...
asked 2 hours ago -
what were the social political and economic causes and impacts of
the late 19th century urban...
asked 2 hours ago -
if the magnitude of a velocity vector is 10m/s and it
makes an angle of 45...
asked 2 hours ago