Evaluate and amortize a structured loan

Reference no: EM1344487

Prepare a model to calculate and amortize a structured loan at a rate of 10 per cent. The cash flow is:

Six rentals of 1,000 on signing

Six further monthly rentals of 1,000

Sixty further rentals of X starting in the next month after the initial rentals

A final rental is payable on expiry of 20,000.00

The model will need to use the factors method to find the subsequent rental X and a cash flow with an IRR could check the final rental.

Reference no: EM1344487

Questions Cloud

Four astronauts are in the spherical space station : If, as is typical, each of them breathes about 500 {rm{ cm}}^3 of air with each breath, approximately what volume of air (in cubic meters) do these astronauts breathe in a year.

Illustrate wwhat is the effect on the market for one hour : Illustrate wwhat is the effect on the market for one hour of babysitting services in Middling today.

Advanced accounting gaap case study : Case Study Question: As a reviewer of BC Securities Commission, you're in the procedure of reviewing the financial statements of public companies.

Establish pmpm rate for primary care physicians : Actuarial estimates project 2,500 visits per 1,000 persons per year. You have contracted with a Primary Care Medical group at dollar 45.00 per visit with a dollar 5.00 co-payment that you will receive.

Evaluate and amortize a structured loan : Prepare a model to evaluate and amortize a structured loan at a rate of 10 per cent.

Does the data support the mayors claim : It was revealed that 120 people had only 1 admission, 81 had 2 admissions, 48 had 3 admissions, 18 had 4 admissions, 18 had 5 admissions, and 15 had 6 admissions or more admissions. Does the data support the mayor's claim? Show the calculations or..

Wilkerson-irwin algorithm to minimize mean tardiness : Write a program to implement the Wilkerson-Irwin algorithm to minimize mean tardiness.

Illustrate what output level would a perfectly competitive : Illustrate what output level would a perfectly competitive firm produce.

Standard deviation or coefficient of variation : Based solely on coefficient of variation, which investment is less risky and given that the expected rates of return are not equal, which is a better measure - standard deviation or coefficient of variation?

User Account

All Pages