Question

In: Accounting

Please note that if n is in months, then r has to be the monthly rate....

Please note that if n is in months, then r has to be the monthly rate. The monthly rate can be found by taking the annual percentage rate (APR) and dividing by 12.

a) Write a function payment that takes in PV, r, and n as inputs, and outputs the payment P.

b) Use the function you wrote above to create a loan amortization table. A loan amortization table will show how much principal is left after each payment and how much interest is paid with each payment. The columns should be principal paid, interest paid, cumulative principal, cumulative interest, and principal balance. So for the loan above, the amortization table would look like:

Principal Paid Interest Paid    Cumulative Prin    Cumulative Int    Principle Balance    

   128.80 83.33    128.80                   83.33                    19871.20

matlab   

Solutions

Expert Solution

Please refer the following table for making the function of Payment.


Related Solutions

a) Show that when relative PPP holds, r(au) = r(eu). Note: r denotes real interest rate....
a) Show that when relative PPP holds, r(au) = r(eu). Note: r denotes real interest rate. b) Assume that worker productivity is expected to increase in European tradables sector in the future. Assume further that worker productivity is expected to stagnate in European nontradables sector as well as in all Australian sectors (tradables and non-tradables) in the future. What implication does this have on the difference between real interest rates in Australia and Europe? c) Do real interest differences imply...
a) Show that when relative PPP holds, r(AU) = r(EU). Note: r denotes real interest rate....
a) Show that when relative PPP holds, r(AU) = r(EU). Note: r denotes real interest rate. b) Assume that worker productivity is expected to increase in the European tradables sector in the future. Assume further that worker productivity is expected to stagnate in European non-tradables sector as well as in all Australian sectors (tradables and non-tradables) in the future. What implication does this have on the difference between real interest rates in Australia and Europe? c) Do real interest differences...
A 5% Treasury note matures in 12 months and has $10,000 face value. If the 6‐months...
A 5% Treasury note matures in 12 months and has $10,000 face value. If the 6‐months and 12‐months zero‐ coupon rates are 3% and 4% respectively, what is the YTM on the Treasury note? Specify your answer as a percentage with 4 digits after the decimal point.
A monthly perpetuity of $100 will start 6 months from today. If the discount rate is...
A monthly perpetuity of $100 will start 6 months from today. If the discount rate is 6% APR compounded monthly, what is the value of the perpetuity today (at time t=0)? Enter answer as a dollar, rounded to nearest dollar.
A growing monthly perpetuity will start 6 months from today. If the discount rate is 6%...
A growing monthly perpetuity will start 6 months from today. If the discount rate is 6% APR compounded monthly, what is the value of the perpetuity today (at time t=0) if the growth rate is 1.2% APR compounded monthly and the first payment is $100? Enter answer as a dollar, rounded to nearest dollar.
Cutting Edge is a monthly magazine that has been on the market for 18 months. It...
Cutting Edge is a monthly magazine that has been on the market for 18 months. It currently has a circulation of 1.4 million copies. Negotiations are underway to obtain a bank loan in order to update the magazine's facilities. Cutting Edge is producing close to capacity and expects to grow at an average of 20% per year over the next 3 years. After reviewing the financial statements of Cutting Edge, Andy Rich, the bank loan officer, had indicated that a...
(Please note that the problem starts by saying "Last year", this means that N will equal...
(Please note that the problem starts by saying "Last year", this means that N will equal 18 (9x2) and not 20 (10x2). Last year Carson Industries issued a 10-year, 12% semiannual coupon bond at its par value of $1,000. Currently, the bond can be called in 6 years at a price of $1,060 and it sells for $1,150. a) a1. What is the bond's nominal yield to maturity? Do not round intermediate calculations. Round your answer to two decimal places....
In an excel spreadsheet, calculate the real interest rate over the past 24 months (using monthly...
In an excel spreadsheet, calculate the real interest rate over the past 24 months (using monthly data) for the 30 year Treasury bond rate as the nominal interest rate and assuming that expected inflation was equal to actual inflation (based on the change in CPI). Make sure to include the Fisher Equation.
A rectangular coil with resistance R has N turns
A rectangular coil with resistance R has N turns, each of length l and width w as shown in Figure P20.25. The coil moves into a uniform magnetic field with constant velocity . What is the magnitude and direction of the total magnetic force on the coil during the following intervals? (Use N, B, w, l,v, and R as needed.)(a) as it enters the magnetic field(b) as it moves within the field(c) as it leaves the field
Prove 1. For each u ∈ R n there is a v ∈ R n such...
Prove 1. For each u ∈ R n there is a v ∈ R n such that u + v= 0 2. For all u, v ∈ R n and a ∈ R, a(u + v) = au + av 3. For all u ∈ R n and a, b ∈ R, (a + b)u = au + bu 4.  For all u ∈ R n , 1u=u
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT