1. In Cell D8 create formula PMT=PV/((1-1/(1+k)^n)/k), to calculate the periodic payment on a loan.
2. In cell F8 use built-in function =PMT(k,n,PV). You should get identical answers.
3. Create amortization table (use absolute and relative addressing where appropriate).
4. Print worksheet.
5. Change loan amount and the rate (everything should adjust automatically) and print it again.
6. Print the cell formulas (force to one page).
7. Write report and explain all formulas and procedures.
8. Submit four printouts.
PMT=$1589.99 per month=$1589.99
Rate per month=0.75%
36 months
Total=$57239.52
Total Interest=$7239.52
Principal=$50000.00
Homework Answers
Hello,
Please see below snapshot. I have hidden few rows as formulas are similar and one snapshot can give entire solution.
Hope this helps.
Add Answer to:
1. In Cell D8 create formula PMT=PV/((1-1/(1+k)^n)/k), to
calculate the periodic payment on a loan.
2....
using Matlab program: Create a loan payment program that can be used for any loan amount...
using Matlab program: Create a loan payment program that can be used for any loan amount such as a home or car loan. The program should ask the user for the input values below, compute the monthly payment, then compute the monthly balance. Display the balance in a table Month Balance 1 $ ##.## 2 $ ##.## 3 $ ##.## . . . etc Use the formula PMT=P*(r(1+r)^n)/((1+r)^n-1) PMT = the monthly payment. P = the principal r = the interest rate per month, which...
Enter a formula in cell C9 using the PMT function to calculate the monthly payment on...
Enter a formula in cell C9 using the PMT
function to calculate the monthly payment on a loan using the
assumptions listed in the Status Quo scenario. In the
PMT formula, use C6 as the
monthly interest rate (rate), C8 as the total
number of payments (nper), and C4 as the loan
amount (pv). Enter this formula in cell C9, and then copy the
formula to the range D9:F9.
C9 A B D E F G 1 2 SpringLeaf Designs...
Please elaborate step by step the pmt(annuity) calculation for this problem Note Payable with Amortization Table: Installment Loan PROBLEM: AS&K, Inc. borrowed S250.000 by issuing an 8%, 3-year n...
Please elaborate step by step the pmt(annuity) calculation for
this problem
Note Payable with Amortization Table: Installment Loan PROBLEM: AS&K, Inc. borrowed S250.000 by issuing an 8%, 3-year note on January 1, 2018. AS&K must make payments every 6 months, beginning June 30, 2018. The note will be fully paid at maturity on December 31, 2020. AS&K prepares annual financial statements. Prepare the amortization table for this note along with any necessary journal entries. Also prepare the t-account for the...
Requiremeht1 Complete the data table DATA Loan Amount Interest Rate Periods 35,000 6% Requirement 2 Using...
Requiremeht1 Complete the data table DATA Loan Amount Interest Rate Periods 35,000 6% Requirement 2 Using the present value of an ordinary annuity table, calculate the payment amount and complete the amortization schedule Use the effective interest amortization method. a. Calculate the loan payment by dividing the loan amount by the appropriate present value factor b. Round values to two decimal places. Calculate the interest expense in the third year as the loan payment minus the loan balance at the...
This worksheet will compute the monthly value of an amortized loan for 36 months. This will...
This worksheet will compute the monthly value of an amortized loan for 36 months. This will be a worksheet in which the loan value or principal, interest rate, and monthly payment can be changed and the worksheet will automatically update. Within the worksheet there will be some absolute cell referencing that is needed and some relative cell referencing that is needed. You will need to determine which is appropriate. Title the worksheet "Amortization of Car Loan" in cell A1. Leave...
This worksheet will compute the monthly value of an amortized loan for 36 months. This will...
This worksheet will compute the monthly value of an amortized loan for 36 months. This will be a worksheet in which the loan value or principal, interest rate, and monthly payment can be changed and the worksheet will automatically update. Within the worksheet there will be some absolute cell referencing that is needed and some relative cell referencing that is needed. You will need to determine which is appropriate. Title the worksheet "Amortization of Car Loan" in cell A1. Leave...
Total Loan amount: The total mortgage loan amount is the amount you borrow after paying your down payment. Here, we assumed that you would pay 20% of the home value (property value) as a down payment. 2. Months: The mortgage payment period is set to 30 ye
Total Loan amount: The total mortgage loan amount is the amount you borrow after paying your down payment. Here, we assumed that you would pay 20% of the home value (property value) as a down payment. 2. Months: The mortgage payment period is set to 30 years. In terms of months, this is equivalent to 30 years multiplied by 12 months. We put our primary basis of payments in terms of months, which is why we need to convert everything...
On 1/1/21, you purchase a used car for $5,000 with a 12% loan (note) payable monthly....
On 1/1/21, you purchase a used car for $5,000 with a 12% loan (note) payable monthly. Payments of principal and interest are made at the end of each month for the next three years. Required a. Compute the amount of your monthly payment. b. Create an effective interest amortization table in Excel for the entire life of the car loan payable using the following columns: payment number, payment date, beginning carrying value, effective interest rate, interest expense, cash paid (principal...
In C. Thank you! Bank Write a program to calculate the monthly payment on a loan...
In C. Thank you!
Bank
Write a
program to calculate the monthly payment on a loan given the loan
amount, interest rate and the number of years to pay off the loan.
Then add a function to print an amortization schedule for that
loan. Create a class to save the current balance and the rest of
the data as private data. Add member functions to make a payment
and to print the amortization report.
Use the following class header. Class...
1. Create an amortization payment table to pay back a loan of 10000 over 4 years at an interest rate of 8% per year...
1. Create an amortization payment table to pay back a loan of 10000 over 4 years at an interest rate of 8% per year. Table should include the Payment, Interest, Principal Repaid, Outstanding Balance for each year.
Enter a formula in cell C9 using the PMT
function to calculate the monthly payment on a loan using the
assumptions listed in the Status Quo scenario. In the
PMT formula, use C6 as the
monthly interest rate (rate), C8 as the total
number of payments (nper), and C4 as the loan
amount (pv). Enter this formula in cell C9, and then copy the
formula to the range D9:F9.
C9 A B D E F G 1 2 SpringLeaf Designs...
Please elaborate step by step the pmt(annuity) calculation for
this problem
Note Payable with Amortization Table: Installment Loan PROBLEM: AS&K, Inc. borrowed S250.000 by issuing an 8%, 3-year note on January 1, 2018. AS&K must make payments every 6 months, beginning June 30, 2018. The note will be fully paid at maturity on December 31, 2020. AS&K prepares annual financial statements. Prepare the amortization table for this note along with any necessary journal entries. Also prepare the t-account for the...
Requiremeht1 Complete the data table DATA Loan Amount Interest Rate Periods 35,000 6% Requirement 2 Using the present value of an ordinary annuity table, calculate the payment amount and complete the amortization schedule Use the effective interest amortization method. a. Calculate the loan payment by dividing the loan amount by the appropriate present value factor b. Round values to two decimal places. Calculate the interest expense in the third year as the loan payment minus the loan balance at the...
In C. Thank you!
Bank
Write a
program to calculate the monthly payment on a loan given the loan
amount, interest rate and the number of years to pay off the loan.
Then add a function to print an amortization schedule for that
loan. Create a class to save the current balance and the rest of
the data as private data. Add member functions to make a payment
and to print the amortization report.
Use the following class header. Class...
1. Create an amortization payment table to pay back a loan of 10000 over 4 years at an interest rate of 8% per year. Table should include the Payment, Interest, Principal Repaid, Outstanding Balance for each year.
Most questions answered within 3 hours.
-
Where is the error in this code sequence?
String s1 = "Hello";
String s2 = "ello";...
asked 10 months ago -
Financial data for Joel de Paris, Inc., for last year
follow:
Joel de Paris, Inc.
Balance...
asked 10 months ago -
Consider this reaction:
Al2(SO4)3 (aq)+ BaCl3
(aq) Al2Cl6 (aq)- +
3BaSO4(s) . What is the...
asked 10 months ago -
Suppose that Savneet is considering increasing her
recent random sample from 20 car rentals to 40...
asked 10 months ago -
Trucks arrive at an unloading terminal at an average rate of 120
per hour.
Trucks arrive...
asked 10 months ago -
Why are methanol and ethanol completely soluble in water while
octanol is not very little soluble....
asked 10 months ago -
A facilities manager at a university reads in a research report
that the mean amount of...
asked 10 months ago -
When the CuSO4 is rehydrated by adding water to the anhydrous
compound, is this an endothermic...
asked 10 months ago -
A ray of sunlight is passing from diamond into crown glass; the
angle of incidence is...
asked 10 months ago -
A block of mass 0.249 kg is placed on top of a light, vertical
spring of...
asked 10 months ago -
how do the kidneys compensate in the presences of acidosis
a) trigger hyperventilate
b) reserve acid...
asked 10 months ago -
Question 501 pts
The rental rate of capital to the firm increases. Which of the
following...
asked 10 months ago