Show working in EXCEL !

Required: Create a Loan Proposal by making up the following step by step and showing ALL WORKINGS. - Clearly stating: o Amount o. Duration and associated payment schedule o Interest Rate - Presentation of a Loan amortization schedule showing for each month: o Loan balance at beginning of month and end of month o Monthly Payment to creditor o Portion of payment to interest each month o Portion of payment to principal each month o Presentation of at least two likely scenarios the business may consider, for e.g. Early repayment of loan, or Extension of Ioan, so as to determine the best repayment or "cash out" schedule