I need tab/ question 3 answered only. Parts 1-5

At 45 years of age, Seth figured he wanted to work only 10 more years. Being a full-time landlord had a lot
of advantages: cash flow, free time, being his own boss—but it was time to start thinking toward retirement.
The real estate investments that he had made over the last 15 years had paid off handsomely. After selling a
duplex and paying the associated taxes, Seth had $350,000 in the bank and was debt-free. With only 10 years
before retirement, Seth wanted to make solid financial decisions that would limit his risk exposure. Fortunately,
he had located another property that seemed to meet his needs— a well maintained four-unit apartment. The
price tag was $250,000, well within his range, and the apartment would require no remodeling. Seth figured he
could invest the other $100,000, and between the two hoped to have $1 million to retire on by age 55.
1. Seth read an article in the local newspaper stating the real estate in the area had appreciated by 5% per year
over the last 30 years. Assuming the article is correct, what would the future value of the $250,000 apartment
be in 10 years?
Initial Investment (PV)
Quoted Rate
Compounding Frequency Choose one
Number of compoundings (m) For Quarterly, type 4; for semiannually, type 2; for annually, type 1; for monthly, type 12; for daily, type 365
Quoted Rate divided by m = RATE
Number of Years
NPER (Num. of years * m)
Ending Amount (FV)
2. Seth’s current bank offers a 1-year certificate of deposit account paying 2% compounded semiannually.
A competitor bank is also offering 2%, but compounded daily. If Seth invests the $100,000, how much more
money will he have in the second bank after one year, due to the daily compounding?
Current Bank Competitor Bank
Semiannually Daily
Initial Investment (PV)
Quoted Rate
Compounding Frequency Choose one
Number of compoundings (m) For Quarterly, type 4; for semiannually, type 2; for annually, type 1; for monthly, type 12; for daily, type 365
Quoted Rate divided by m = RATE
Number of Years
NPER (Num. of years * m)
Ending Amount (FV)
Difference in FV =D36-C36
3. After looking at the results from questions 1 and 2, Seth realizes that a 2% return in a certificate of deposit
will never allow him to reach his goal of $1 million in 10 years. Presuming his apartment will indeed be worth
$400,000 in 10 years, compute the future value of Seth’s $100,000 investment using a 10%, 15%, and 20% return
compounded semiannually for 10 years. Will any of these rates of return allow him to accomplish his goal of
reaching $1 million by age 55?
10% 15% 20%
Initial Investment (PV)
Quoted Rate
Compounding Frequency Semiannually Semiannually Semiannually
Number of compoundings (m)
Quoted Rate divided by m = RATE
Number of Years
NPER (Num. of years * m)
Ending Amount (FV)
Plus: Apartment Value $400,000 $400,000 $400,000
Total FV =FV + Apartment Value
Which rate of return allows him to accomplish his goal of reaching $1 million? Choose one
4. A friend of Seth’s who is a real estate developer needs to borrow $80,000 to finish a development project.
He is desperate for cash and offers Seth 18%, compounded monthly, for 2.5 years. Find the future value of
the loan.
Initial Investment (PV)
Quoted Rate
Compounding Frequency Choose one
Number of compoundings (m) For Quarterly, type 4; for semiannually, type 2; for annually, type 1; for monthly, type 12; for daily, type 365
Quoted Rate divided by m = RATE
Number of Years
NPER (Num. of years * m)
Ending Amount (FV)
5. After purchasing the apartment, Seth receives a street, sewer, and gutter assessment for $12,500 due in 2 years.
How much would he have to invest today in a CD paying 2%, compounded semiannually, to fully pay the assessment in 2 years?
Future Value Needed (FV)
Quoted Rate
Compounding Frequency Choose one
Number of compoundings (m) For Quarterly, type 4; for semiannually, type 2; for annually, type 1; for monthly, type 12; for daily, type 365
Quoted Rate divided by m = RATE
Number of Years
NPER (Num. of years * m)
Amount Invested Now (PV)

I have included the excel sheet for completion. Please complete tab/ question 3 parts 1-5 only.

You can leave a response, or trackback from your own site.

CLICK ORDER NOW TO GET A CUSTOMIZED PAPER ON THIS TOPIC JUST FOR YOU!! 0%PLAGIARISM 100% ORIGINAL PAPER

8 Responses to “I need tab/ question 3 answered only. Parts 1-5”

  1. Dream Proxies

    I have included the excel sheet for completion. Please complete tab/ question 3 parts 1-5 only.

  2. 50 Discount For All Private Proxies! Elite quality, Unlimited bandwidth, 1000 mb/s superspeed, 99,9 uptime, Non successive IP’s, No use restrictions, Multiple subnets, USA or Europe proxies – Buy Today – https://DreamProxies.com

  3. 77163 601261How can I attract much more hits to my composing weblog? 296697

  4. It’s difficult to acquire knowledgeable individuals during this topic, but the truth is be understood as guess what happens you’re dealing with! Thanks

  5. Thanks for all your work on this blog. My mother really loves managing research and it’s easy to understand why. Almost all learn all about the powerful means you deliver good items by means of your blog and therefore encourage response from others about this subject matter then my child is truly studying a lot of things. Take pleasure in the rest of the new year. You are doing a stunning job.

  6. 670470 974588A thoughtful opinion and suggestions Ill use on my internet page. Youve certainly spent some time on this. Well carried out! 193273

  7. Research says:

    462610 125376I besides believe therefore , perfectly composed post! . 669759

  8. 526759 42875Terrific paintings! That is the kind of information that should be shared across the net. 192877

Leave a Reply

Powered by WordPress | Designed by: buy backlinks | Thanks to webdesign berlin, House Plans and voucher codes