Time Value of Money Use Excel Functions to correctly calculate

Time Value of Money Use Excel Functions to correctly calculate

Question # 00129814 Posted By: solutionshere Updated on: 11/05/2015 01:15 AM Due on: 12/05/2015
Subject Economics Topic General Economics Tutorials:
Question
Dot Image
Problem Assignment: Time Value of Money
Use Excel Functions to correctly calculate answers to all problems below
Explain in words what you do to make each calculation
Explain in words what the answers mean
In problems with an A and B part, explain what you learn from the difference
1
Answer: $16,242.85 Point Value Point Value 3.0%
USE FV Function
2
Answer: $6,219.41 Point Value Point Value 3.0%
USE PV Function
3 a
Answer: $326,889.00 Point Value 3.0%
USE PV Function
3 b
Answer: You calculate Point Value 5.0%
USE PV Function
4 a
Answer: 31.15 years Point Value 3.0%
USE NPER Function
4 b
Answer: You calculate Point Value 5.0%
USE NPER Function
5 a
Answer: -$1,054.01 Point Value 3.0%
NPER Rate
House price $300,000 30 years 3.0000% Annual
Down $50,000 360 NPER 0.2500%
Mortgage $250,000
USE PMT Function
5 b
Answer: You calculate Point Value 5.0%
NPER Rate
House price $300,000 30 years 2.5000% Annual
Down $50,000 360 NPER 0.2083%
Mortgage $250,000
USE PMT Function
6
Answer: 7.12% Point Value 5.0%
USE RATE Function
NPER
30 years
360 NPER
7
Answer: 7.45% Point Value 5.0%
Year 2015
Year 2000
NPER 15
8 a
Answer: $2,050,008.05 Point Value 5.0%
PV -$50,000.00
PMT -$9,000.00
8 b
Answer: You calculate Point Value 5.0%
9
Year Cash Flow
2016 $22,000
2017 $24,000
2018 $29,000
2019 $30,000
2020 $31,000
2021 $27,000
2022 $22,000
2023 $15,000
2024 $12,000
Answer: $72,134.42 Point Value 5.0%
10
10a
10.0%
Hint: Cash Flow timeline
Month Cash Flow
0 -$4,300.00
1 -$324.00
2 -$324.00
3 -$324.00
4 -$324.00
xxx -$324.00
36 -$324.00
37 -$25,000.00
Answer: $35,737.40
10b
5.0%
Answer: $972.22
10c
5.0%
Answer: You create
10d
5.0%
Answer: You calculate
10e
5.0%
Answer: You calculate
10f
5.0%
Answer: You calculate
10g
Answer: You calculate 5.0%
10h
5.0%
Be sure to explain what you do in words.
Also, tell what the answer means.
In problems with both part a and part b, compare the two answers. Total 100.0%
In each case, you should be able to do part b if you can do part a.
Please send an e-mail with questions to me or to our T/A.
First try, then reach out. Do not suffer in silence
Dot Image
Report this Question as Inappropriate
Tutorials for this Question
  1. solutionshere
    Tutorial # 00124245 Posted By: solutionshere Posted on: 11/05/2015 01:15 AM
    Puchased By: 3
    Tutorial Preview
    The solution of Time Value of Money Use Excel Functions to correctly calculate...
      Get the Solution
    Attachments
    Copy_of_Time_Value_of_Money_Problems_(1).xls (109.5 KB)
    10_(a)_to_(h).xlsx (17.61 KB)
    Copy_of_Time_Value_of_Money_Problems.xls (109.5 KB)
    Recent Feedback
    Rated By Feedback Comments Rated On
    Hel...d45 Rating All the assignments were as per the requirement 02/29/2016
  Get the Solution

Great! We have found the solution of this question!

Related Questions and Answers

Whatsapp Lisa