Write a model to calculate and amortize a structured loan of 10 %….

Write a model to calculate and amortize a structured loan of 10 %. 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 ispayable 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 Must be in excel and show detail and formula