Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Sep 28, 2024

How do you calculate this function on Excel to get the answer provided? Rutherford Hayes has borrowed $80000 as mortgage loan at 7.5% interest rate

How do you calculate this function on Excel to get the answer provided?

Rutherford Hayes has borrowed $80000 as mortgage loan at 7.5% interest rate and 30-year term. He has to pay the loan in monthly installments. After how many payments will the unpaid balance become $40000? (Answer: 264.94 months)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

Get Instant Access to Expert-Tailored Solutions

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

Step: 2

Step: 3

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

National Finance A Chinese Perspective

Authors: Yunxian Chen, Heming Yong

1st Edition

9813360917, 978-9813360914

More Books

Students also viewed these Finance questions

Question

★★★★★

John Goodheart wishes to provide for six annual withdrawals of $3,000 each beginning January 1, 2017. He wishes to make 10 annual deposits beginning January 1, 2007, with the last deposit to be made...

Answered: 1 week ago

Question

★★★★★

Your company is planning to borrow $2.75 million on a 3-year, 11%, annual payment, fully amortized term loan. What fraction of the payment made at the end of the second year will represent repayment...

Answered: 1 week ago

Question

★★★★★

2. Suppose that changes in bank regulations expand the availability of credit cards, so that people need to hold less cash. a. How does this event affect the demand for money? b. If the Bank of...

Answered: 1 week ago

Question

★★★★★

Riff CD Company has had 4 years of retained earnings. Due to this success, the market price of its 400,000 shares of $3 par value common stock has increased from $12 per share to $51. During this...

Answered: 1 week ago

Question

★★★★★

Since the two foreign currency flows will occur simultaneously (outflow and inflow), what can you do rather than hedge with financial derivatives? What can you say about operational hedging

Answered: 1 week ago

Question

★★★★★

What is the upper bound of an American call option with 10 months to expiry and a strike price of 9.2. The underlying stock is currently trading at 18.4, and the risk-free rate is 9.3%. Do not enter...

Answered: 1 week ago

Question

★★★★★

Partners D, E and F share profits in the ratio of 5:3:2, During January, first installment of liquidation, D and E received P6,000 and P1,000 respectively. On the following month E received P6,000,...

Answered: 1 week ago

Question

★★★★★

Sue's Cupcakes hires your marketing firm to assist in determining which cupcakes were the top seller on National Cupcake Day last year. The results will help the company determine the top-selling...

Answered: 1 week ago

Question

★★★★★

Modeled after the two satellites problem (slide 12 in Lecture13, Universal gravity), imagine now if the period of the satellite is exact 46.91 hours, the earth mass is 5.98 x 1024 kg, and the radius...

Answered: 1 week ago

Question

★★★★★

1. A nurseis preparing to initiate IV therapy for an older adult client. Which of the following actions should the nurse plan to take ? a. Clean the site using vigorous friction b. Apply a tourniquet...

Answered: 1 week ago

Question

★★★★★

You plan to invest in securities that pay 8.0%, compounded annually. If you invest $5,000 today, how many years will it take for your investment to grow to $9,140.20? Using the information in the...

Answered: 1 week ago

Question

★★★★★

Lets say a company has nine divisions, and each division has a different check number based on its divisionso one starts with 1, another with 2, and so on. Would Benfords law work in this situation?

Answered: 1 week ago

Question

★★★★★

How does the computation of summary statistics (mean, mode, median, max, min, etc.) meet the definition of descriptive analytics?

Answered: 1 week ago

Question

★★★★★

A sequence check will help us to see if there is a duplicate payment to vendors. Why is that important for the auditor to find?

Answered: 1 week ago

Previous Question Next Question