Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please and thank you (b) (18 marks) A wealthy family friend nicknamed Lecce had offered to help Tiffany and has made an alternative offer for

please and thank you
image text in transcribed
(b) (18 marks) A wealthy family friend nicknamed Lecce had offered to help Tiffany and has made an alternative offer for her to obtain the $10,000 loan. Lecce has proposed the following loan terms over a 12-month period. He claims this is a 'cheaper and simple' with everything paid off at the end of the renovation. Lecce will give her the $10,000 at the start of the month and Tiffany will start pay $900 at the each of each month for until the end of the loan period. He claims he is entitled to $800 in interest, which will be paid to him under his proposed conditions. Tiffany would like to know the interest rate Lecce is charging her and they would also like to verify the total amount of interest ($800) he claims he is entitled to. To answer this question, follow all EXCEL instructions below- including the in- structions given in the two diagrams. Also show your calculation for the total interest Tiffany paid under this arrangement. EXCEL Instructions: You will need to set up a new Amortisation schedule, like the one shown below, for the 12-month loan. For full marks provide: (i) a copy of your Excel spreadsheet that looks similar to the one below and (ii) your calculation for the total interest to verify Lecce's $800 claim. Set up the amortisation schedule: Set up your amortisation schedule, as shown below. Ensure you extend it to show all 12 months. Read the instructions in the boxes for more information. The following figure includes the given numbers. torowed amount rest rate Comp Frency Repaym Month -30 $ 14,000.00 10% with y este be 1 1000.00 125 Opening Balarve Repayment 15 15,000.00 $ LOGOS 6.771.355 -864 4,106.37 tered LOGO $ 1,000.00 $ -5852/5 Prisopel 31.365 47:34 S 21.41 E -C0 Clos Balance 31441'S M 20.075 SMIL 176393 AU G

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Finance questions

Question

How well do you work in teams?

Answered: 1 week ago

Question

Identify three types of physicians and their roles in health care.

Answered: 1 week ago

Question

Compare the types of managed care organizations (MCOs).

Answered: 1 week ago