Plan2go, a corporate travel and events management company, are setting up their new…

Plan2go, a corporate travel and events management company, are setting up their new offices in Sydney due to their expansion and the development of their new Plan2go App. You have just accepted a new role as finance support officer as part of Coin Control – the finance department. Your role is to assist in scoping out and costing the new premises including the equipment needed for the office fit-out and set-up. You will be using financial calculations and creating worksheets to complete this task. Complete your answers in this Excel spreadsheet template with eight (8) worksheets, save the file on your computer and follow the instructions to submit to the online area for this assessment event. Use naming conventions in the Excel spreadsheet including headers and footers in accordance with the Plan2go records management policy and adapt each worksheet using page 12 of the Plan2go Brand toolkit and style guide. You will need to complete the following worksheets for Assessment Event 3. Worksheet 1 Loan Payments The Procurement Officer has estimated that Plan2go will need a loan of $355,000 to fund the purchase of the computer equipment, hardware and software to produce the App. The Commonwealth Bank has offered an interest rate of 8.54% and a loan term of 60 months (5 years) with payments made monthly and no residual or balloon payment due. Use the PMT function in Excel to figure out what the loan repayment will be each month