Problem 1.10 INPUT PV= $ 6,000.00 FV= $ 10,000.00 RATE= ? TIME= 5 PMT= 0 OUTPUT RATE= #NUM!...
| Problem 1.10 | |
| INPUT | |
| PV= | $ 6,000.00 |
| FV= | $ 10,000.00 |
| RATE= | ? |
| TIME= | 5 |
| PMT= | 0 |
| OUTPUT | |
| RATE= | #NUM! |
| Problem 1.13 | |
| INPUT | |
| PV= | $ 30.00 |
| FV= | $ 60.00 |
| RATE= | 7% |
| TIME= | ? |
| PMT= | 0 |
| OUTPUT | |
| TIME= | |
| Problem 1.17 | |
| INPUT | |
| PV= | $ - |
| FV= | $ 120,000.00 |
| RATE= | 5% |
| TIME= | 18 |
| PMT= | 0 |
| OUTPUT | |
| PMT= | |
On the Excel, Is there any order to put first? for example, =Rate(-PV,FV,TIME,PMT) Like that kind of order?
I put this way, but it shows up like that (#NUM!)
Also, PMT order, Time order please.
Homework Answers
calc:
Add Answer to:
Problem 1.10
INPUT
PV=
$ 6,000.00
FV=
$ 10,000.00
RATE=
?
TIME=
5
PMT=
0
OUTPUT
RATE=
#NUM!...
when we use the calculator for this problem, n=9, PV = -0.7, PMT = 0, and...
when we use the calculator for this problem,
n=9, PV = -0.7, PMT = 0, and FV = 2.11
why is the PMT zero when the investors still receive dividend
every year?
can we use the CF function on calculator and input all
divends. for ex, CF0 = 0.7, CF1 = 0.8, etc.
Problem Johnson & Johnson paid the following dividends per share from 2001 to 2010: Johnson & Johnson Annual Dividends 2001 2002 2003 2001 2002 2003 2004 |...
a. Find the FV of $1,000 invested to earn 10% annually 5 years from now. Answer...
a. Find the FV of $1,000 invested to earn 10% annually 5 years from now. Answer this question by using a math formula and also by using the Excel function wizard. Inputs: PV = 1000 I/YR = 10% N = 5 Formula: FV = PV(1+I)^N = Wizard (FV): $1,610.51 Note: When you use the wizard and fill in the menu items, the result is the formula you see on the formula line if you click on cell E12. Put the...
Just need to know the N, I/YR, PV, PMT, and FV values for each problem to...
Just need to know the N, I/YR, PV, PMT, and FV values for each problem to input into financial calculator. Please specify the periods per year and if need to set in Beg or End. -Calculate the future value of the following amounts: a. $8,250 invested for 18 years at 5.2% per year; b. $4,015 invested for 25 years at 14.5% per year; -Calculate the present value: a. $15,000 42 years from now, discounted at 8.4% per year; b. $8,550...
I need help on question 2. MODULE IV: TIME VALUE OF MONEY INTRODUCTION The time value...
I need help on question 2.
MODULE IV: TIME VALUE OF MONEY INTRODUCTION The time value of money analysis has many a lysis has many applications, ranging from setting hedules for paying off loans to decisions about whether to invest in a partie financial instrument. First, let's define the following notations: I = the interest rate per period Na the total number of payment periods in an annuity PMT = the annuity payment made each period PV = present value...
Time Value of Money Spreadsheet Example 4 Module IV Name: Date: 6 7 8 Question 1 9 Question 2 10 Question 3 11 Question...
Time Value of Money Spreadsheet Example 4 Module IV Name: Date: 6 7 8 Question 1 9 Question 2 10 Question 3 11 Question 4 12 Question 5 13 Question 6 14 Question 7 15 Question 8 16 Question 9 17 Question 10 18 19 20 Single Amount or Annuity 21 Periodic Interest Rate 22 Number of Periods 23 24 25 Present Value of Single Amount 26 27 Future Value of Single Amount 28 29 Future Value of An Annuity...
Time Value of Money In solving these problems please use Excel formulas of the time value of money valuation including : Present Value / PV, Future Value / FV, interest Rate / Rate, Number of periods...
Time Value of Money In solving these problems please use Excel formulas of the time value of money valuation including : Present Value / PV, Future Value / FV, interest Rate / Rate, Number of periods / NPER First National Bank TIME VALUE OF MONEY ANALYSIS You have applied for a job with a local bank. As part of its evaluation process, you must take an examination on time value of money analysis covering the following questions: 1. Draw time...
FUTURE VALUE ANNUAL DEPOSIT INTEREST RATE/GROWTH RA 4.00% ASSUMES DEPOSIT AT BEGINNING OF TIME-0 Compolunding Period...
FUTURE VALUE ANNUAL DEPOSIT INTEREST RATE/GROWTH RA 4.00% ASSUMES DEPOSIT AT BEGINNING OF TIME-0 Compolunding Period TIME (YRS)DEPOSITEND OF YR FORMULATEXT SINGLE FORMULA FORMULATEXT END OF YR $43,167.12FV(SB$4,A27,-$B$3,,$B$6) 0 $1,500.00 $ 1,560.00 B8 (1+SBS4)AB6 1 $1,500.00 3,182.40(C8+B9)(1+SB$4)ASB$6 2 $1,500.00 $ 4,869.70 (C94B10)1+SB$4)n$B$ N THIS CASE THERE IS A DEPOSITY OF $1,500 EVERY YEAR. IN THE 3 $1,500.00 6,624.48 (C104811) (1 SB$4)ASB$6FV FUNCTION, WE ENTER THIS AS A NEGATIVE PAYMENT INSTEAD OF PV. 4 $1,500.00 $ 8,449.46 11+812)"(1+5B54)^SB$6 5 $1,500.00 10,347.44...
1. What is the firm’s cost of debt? (Pre tax) Cost of debt, Kd = YTM of the bond = 2 x RATE (Period, PMT, PV, FV) = 2 x...
1. What is the firm’s cost of debt?
(Pre tax) Cost of debt, Kd = YTM of the bond = 2 x RATE (Period,
PMT, PV, FV) = 2 x RATE (2 x 5, 12%/2 x 1000, -1080, 1000) = 2 x
RATE (10, 60, -1080, 1000) = 9.93%
2. What is the cost of preferred stock for Whatcom Co.?
Ks = Annual dividend / Current price = 11% x 100 / 104 =
10.58%
3. Cost of common equity...
You have recently been hired as a consultant for a personal financial planning firm. One of...
You have recently been hired as a consultant for a personal financial planning firm. One of your first projects is creating a retirement plan for a couple, Xavier and Elizabeth Martell. They have just celebrated their 40th birthdays and after paying for their children’s education, they have decided to get serious about saving for retirement. Xavier and Elizabeth hope to retire 25 years from now (on their 65th birthdays), and they expect to live until age 90. Their hope is...
Assignment 5 will be way different. It will be more like what you will receive in...
Assignment 5 will be way different. It will be more like what
you will receive in a programming shop. By that I mean that some
things are built for you and others you will need to create or
finish. P.S. part of your grade will include: Did you add in the
required files? Did you rename your project? does your linear
searches work? Did you put your code in the correct modules? did
you change modules that you weren't supposed...
when we use the calculator for this problem,
n=9, PV = -0.7, PMT = 0, and FV = 2.11
why is the PMT zero when the investors still receive dividend
every year?
can we use the CF function on calculator and input all
divends. for ex, CF0 = 0.7, CF1 = 0.8, etc.
Problem Johnson & Johnson paid the following dividends per share from 2001 to 2010: Johnson & Johnson Annual Dividends 2001 2002 2003 2001 2002 2003 2004 |...
I need help on question 2.
MODULE IV: TIME VALUE OF MONEY INTRODUCTION The time value of money analysis has many a lysis has many applications, ranging from setting hedules for paying off loans to decisions about whether to invest in a partie financial instrument. First, let's define the following notations: I = the interest rate per period Na the total number of payment periods in an annuity PMT = the annuity payment made each period PV = present value...
Time Value of Money Spreadsheet Example 4 Module IV Name: Date: 6 7 8 Question 1 9 Question 2 10 Question 3 11 Question 4 12 Question 5 13 Question 6 14 Question 7 15 Question 8 16 Question 9 17 Question 10 18 19 20 Single Amount or Annuity 21 Periodic Interest Rate 22 Number of Periods 23 24 25 Present Value of Single Amount 26 27 Future Value of Single Amount 28 29 Future Value of An Annuity...
FUTURE VALUE ANNUAL DEPOSIT INTEREST RATE/GROWTH RA 4.00% ASSUMES DEPOSIT AT BEGINNING OF TIME-0 Compolunding Period TIME (YRS)DEPOSITEND OF YR FORMULATEXT SINGLE FORMULA FORMULATEXT END OF YR $43,167.12FV(SB$4,A27,-$B$3,,$B$6) 0 $1,500.00 $ 1,560.00 B8 (1+SBS4)AB6 1 $1,500.00 3,182.40(C8+B9)(1+SB$4)ASB$6 2 $1,500.00 $ 4,869.70 (C94B10)1+SB$4)n$B$ N THIS CASE THERE IS A DEPOSITY OF $1,500 EVERY YEAR. IN THE 3 $1,500.00 6,624.48 (C104811) (1 SB$4)ASB$6FV FUNCTION, WE ENTER THIS AS A NEGATIVE PAYMENT INSTEAD OF PV. 4 $1,500.00 $ 8,449.46 11+812)"(1+5B54)^SB$6 5 $1,500.00 10,347.44...
1. What is the firm’s cost of debt?
(Pre tax) Cost of debt, Kd = YTM of the bond = 2 x RATE (Period,
PMT, PV, FV) = 2 x RATE (2 x 5, 12%/2 x 1000, -1080, 1000) = 2 x
RATE (10, 60, -1080, 1000) = 9.93%
2. What is the cost of preferred stock for Whatcom Co.?
Ks = Annual dividend / Current price = 11% x 100 / 104 =
10.58%
3. Cost of common equity...
Assignment 5 will be way different. It will be more like what
you will receive in a programming shop. By that I mean that some
things are built for you and others you will need to create or
finish. P.S. part of your grade will include: Did you add in the
required files? Did you rename your project? does your linear
searches work? Did you put your code in the correct modules? did
you change modules that you weren't supposed...
Most questions answered within 3 hours.
-
Write a method that determines the key of the successor of the
root node in a...
asked 8 minutes ago -
Determine the lattice energy (in kJ/mol) of NaF(s),
using the data provided.
Energy to sublime Na(s)...
asked 16 minutes ago -
How do you explain the deviations from Hardy-Weinberg
equilibrium in a population where smoking has effected...
asked 25 minutes ago -
As a general rule, testing should be conducted until all bugs
have been detected.
A. True....
asked 29 minutes ago -
Just before a referendum on a school budget, a local newspaper
polls
436
voters to predict...
asked 30 minutes ago -
3) Consider the combustion reaction for octane (C8H18), which is
a primary component of gasoline.
2C8H18+25O2⟶16CO2+18H2O...
asked 34 minutes ago -
A protein molecule in an electrophoresis gel has a negative
charge. The exact charge depends on...
asked 34 minutes ago -
we have seen the development of e-commerce in the last 20 years
, what do you...
asked 50 minutes ago -
Two blocks are sliding toward one another along a level
horizontal surface. One block is moving...
asked 54 minutes ago -
Oklahoma Corp. uses the indirect method to prepare its statement
of cash flows. Refer to the...
asked 1 hour ago -
A 1.5 m long string is tied between two posts. what is the
wavelength of the...
asked 1 hour ago -
The personnel office at a large electronics firm regularly
schedules job interviews and maintains records of...
asked 1 hour ago