View the step-by-step solution to:

ACST201 Financial Modelling Online Quiz Today is 1 January 2018. MQU bank is offering a 5 year $100,000 loan product to its customers.(25 marks).

ACST201 Financial Modelling Online Quiz

Today is 1 January 2018. MQU bank is offering a 5 year $100,000 loan product to its customers.(25 marks).

a. [10 marks] This loan product requires customers to make monthly repayment. Payment will be paid at the beginning of each month with an amount of $2,000. Use the Goal Seek to find the implied annual nominal rate of interest payable monthly (i.e., j12) charged by MQU bank.

b. [8 marks] For this loan product, each customer needs to pay an initial cost of $200 at the beginning of the loan. Use the Goal Seek to find the real borrowing cost for a customer (expressed as an annual rate payable monthly j12). This loan product requires customers to make monthly repayment. The payment will be paid at the beginning of each month with an amount of $2,000.

c. [7 marks] Assume that customers also have the yearly, half yearly and quarterly payment options. Using these options, customers are required to have payment at the end of each period (i.e., at end of each year, half-year and quarter). Assume that the MQU bank charges an annual nominal rate of interest j1 = 7.5% p.a. for these payment options. Find the customer's quarterly, half yearly and yearly payment amount. Use a bar or column chart to plot the quarterly, half yearly and yearly payment amount.

Present your answers to the above questions in a functional Excel spreadsheet


http://ilearn.mq.edu.au/pluginfile.php/4962954/mod_resource/content/18/SPT1_question_pdf.pdf

Recently Asked Questions

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question