Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

QUESTION 8 3 points Which of the following sets of Excel entries will correctly solve this problem: Jim paid $138,000 for an old house to

image text in transcribed

QUESTION 8 3 points Which of the following sets of Excel entries will correctly solve this problem: Jim paid $138,000 for an old house to renovate. He spent an average of $3,216 per quarter over the next two years as he readied the renovated house for sale. He wants to set the price of the house high enough so that he will earn an annual rate of return of 12% for his investment. Given that information, what price should Jim set on the house? ONPER=8 RATE=3.0000% PV=($138,000) PMT=($3,216) solve for FV ONPER=8 RATE=3.0000% PV=($138,000) PMT=$3,216 solve for FV ONPER=2 RATE=12.0000% PV=($138,000) PMT=($12,864) solve for FV ONPER=24 RATE=1.0000% PV=($138,000) PMT=($3,216) solve for FV QUESTION 9 5 points Cindy and Mike managed to save $314,000 in their retirement account, which earns 7.2 percent annual interest. They plan to live on this money and will begin withdrawing $6,000 per month out of the account until the money in the account is gone. How long, in months, will their money last? (Show your answer to two decimals, e.g., 12.34; fractional months are okay)

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_2

Step: 3

blur-text-image_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

IT Audit In China

Authors: LIU Ruzhuo

1st Edition

981428145X, 978-9814281454

More Books

Students also viewed these Accounting questions

Question

Explain in detail of distribution channel for Mydin.

Answered: 1 week ago