Question: please solve this problems by using excel formulas. THanks! Calculate the answers for the below questions in cells C3 to C10 using Excel TVM functions.

please solve this problems by using excel formulas. THanks! Calculate the answers for the below questions in cells C3 to C10 using Excel

please solve this problems by using excel formulas. THanks!

Calculate the answers for the below questions in cells C3 to C10 using Excel TVM functions. Use AT LEAST ONE of Excel's TVM functions among =PV,=FV,=PMT,=RATE,=NPER,=IPMT,=PPMT,=CUMIPMT,=CUMPRINC to answer each question. New Scenario (Independent): Robert takes out a loan today. The interest rate is 8.4% p.a. compounded quarterly. To fully repay the loan, Robert will make quarterly repayments of $9352 starting in 7 years. He needs to make 68 repayments in total. Calculate the orginal loan Robert borrows. New Scenario (Independent): Daniel takes out a $158984 mortgage loan today. The interest rate is 8.2% p.a. compounded monthly. To fully repay the loan, he needs to make 34 equal monthly repayments of $4676 starting in one month. Daniel will also make a final repayment at the end of month 35 . Calculate the amount of the final repayment

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Could you solve these problems with excel formulas? Thanks. Calculate the answers for the below questions in cells C3 to C10 using Excel TVM functions. Use AT LEAST ONE of Excel's TVM functions among...

MY QUESTION: I have the answer to both of the questions by using a calculator, but the problem is I need to use one of the following Excel functions, in an excel document, to find these answers: "...

24 Q5 06 Formulas Review View Draw Data Tell me Page Layout x fx D B WACT1001 Excel Assignment PART B (8 marks) Based on your amortisation schedule, calculate the answers for the below questions in...

Time Value of Money: Single Cash Flows Introduction Time value of money (TVM) is the foundation of mathematical finance. This assignment is designed to show you how the TVM concept can be applied to...

I need help from a finance tutor with questions P17-1, P17-2, and P18-8. Please read the instructions on page one carefully. Instructions NAME: To complete the homework assignments in the templates...

Project Objectives: Use Microsoft Excels charts and formulas to analyze a companys financial statement and sales performance; Write business report based on data analysis and incorporate Excel charts...

Dr.Ramsey Please assist me with my discussion post. Subject: Annuities Systematic risk evaluates the probability and extent of negative consequences to the larger body. For example, the government...

Question 2 , sub parts a,b,c Question 2 , sub parts a,b,c please 1. (75 points total) A half section of irrigated farmland (i.e., 320 acres) has just become available and you figure it can be...

sub parts for a,b,c, d please 1. (75 points total) A half section of irrigated farmland (i.e., 320 acres) has just become available and you figure it can be purchased for $7,500/acre. You have...

Alicia Arden has established herself as a very effective sales representative for products related to health care services. While she has worked independently for a number of years, she has received...

Metal window boxes are manufactured in two process steps: stamping and assembly. Each window box is made up of three pieces: a base (one part A) and two sides (two part Bs). The parts are fabricated...

BE16.11 (LO 4) Hillsborough Co. has a held-for-collection investment in the bonds of Schuyler Corp. with a carrying (and fair) value of $70,000. Due to poor economic prospects for Schuyler,...

Fill in the Blanks Beginning inventory Purchases Purchase returns and allowances Purchase discounts Net purchase Freight in Cost of goods purchased Cost of goods available for sale Ending inventory...