Prepare a model to evaluate and amortize a structured loan, Ask an Expert

Finance

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.

View complete question

Basic Finance, Finance

Category:- Basic Finance
Reference No.:- M9219851

Have any Question?Write your Review or question?

Related Questions in Basic Finance

Have the federal governments policies on drugs and

Have the federal government's policies on "drugs" and "narcotics" been successful?

Deyoung entertainment enterprises is considering replacing

DeYoung Entertainment Enterprises is considering replacing the latex molding machine it uses to fabricate rubber chickens with a newer, more efficient model. The old machine has a book value of $450,000 and a remaining u ...

Company b has a beta of 061 the rate on australian treasury

Company B has a beta of 0.61, the rate on Australian Treasury Bonds is 4.75% and the expected return for the S&P/ASX 200 Index is 20.35%. Required: a) Calculate the required return (ie Expected Return) for Pacific Blue L ...

Confused on this one would appreciate any helpthe following

Confused on this one. Would appreciate any help. The following information relates to Lobo Corporation: Cash $20,000 Accounts receivable $50,000 Marketable securities ...

Eggsinc reported earnings available to common stock of

Eggs,Inc. reported earnings available to common stock of $4200000 last year. From these earnings, the company paid a dividend of $1.26 on each of its 1000000 common shares outstanding. The capital structure of the compan ...

Every year for the past five years flights r us has paid a

Every year for the past five years, Flights 'R Us has paid a constant dividend of $2.50 per share. Next year and every year after, Flights 'R Us will increase the dividend rate 2.5% per year. If investors require a 15% r ...

The inside door has total debt of 76662 total equity of

The Inside Door has total debt of $76662, total equity of $224477, and a return on equity of 12.7 percent. What is the return on assets? Input your answer as a decimal rounded to 4 places (i.e., 1% = 0.0100).

Please show formula and detailed explanationyou have just

Please show formula and detailed explanation. You have just purchased an investment that generates the following cash flows for the next four years. You are able to reinvest these cash flows at 11.1 percent, compounded a ...

Yrb corporation has 400 million outstanding shares yrbs

YRB Corporation has 400 million outstanding shares. YRB's expected cash distributions (per share) next year are $5.00, comprised of $3.00 of dividends and $2.00 of share repurchases. This mix of dividends to total distri ...

How could legislation impact on operations within your

How could legislation impact on operations within your organisation in relation to innovation, project management, and operational planning? Briefly outline any relevant requirements (e.g. intellectual property, WHS).

4,153,160 Questions Asked
13,132 Experts
2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Recent Questions

Ask Basic Finance Expert