a.
To calculate: Future value of $1,000 after 5 years at 10% annual interest rate.
Introduction:
a.

Explanation of Solution
Calculation in spreadsheet by “FV” formula,
Table (1)
Steps required to calculate
- Select ‘Formulas’ option from Menu Bar of Excel sheet.
- Select insert Function that is (fx).
- Choose category of Financial.
- Then select “FV” and then press OK.
- A window will pop up.
- Input data in the required field.
- Final answer will be shown by the formula that is $1,610.50.
Future value of $1,000 is $1,610.51.
b.
To calculate: Investments future value at 0%,5% and 20% rate after 0,1,2,3,4 and 5 years.
Introduction:
Time Value of Money: It is a vital concept to the investors, as it suggests them the money they are having today is worth more than the value promised in the future.
b.

Explanation of Solution
Calculation spreadsheet by “FV” formula,
Table (2)
Steps required to calculate present value by using “FV” function in excel are given,
- Select ‘Formulas’ option from Menu Bar of Excel sheet.
- Select insert Function that is (fx).
- Choose category of Financial.
- Then select “FV” and then press OK.
- A window will pop up.
- Input data in required field.
Investment future values are different for the different years with 0%, 5% and 20% interest rate.
c.
To calculate: Present value due of $1,000 in 5 years at the discount rate of 10%.
Introduction:
Time Value of Money: It is a vital concept to the investors, as it suggests them the money they are having today is worth more than the value promised in the future.
c.

Explanation of Solution
Calculation in spreadsheet by “PV” formula,
Table (3)
Steps required to calculate present value by using “PV” function in excel are given,
- Select ‘Formulas’ option from Menu Bar of Excel sheet.
- Select insert Function that is (fx).
- Choose category of Financial.
- Then select “PV” and then press OK.
- A window will pop up.
- Input data in the required field.
- Final answer will be shown by the formula that is $620.92.
Present value of $1,000 is $620.92 at 10 % discount rate.
d.
To calculate:
Introduction:
Time Value of Money: It is a vital concept to the investors, as it suggests them the money they are having today is worth more than the value promised in the future.
d.

Explanation of Solution
Calculationin spreadsheet by “RATE” formula,
Table (4)
Steps required to calculate present value by using “RATE” function in excel are given,
- Select ‘Formulas’ option from Menu Bar of Excel sheet.
- Select insert Function that is (fx).
- Choose category of Financial.
- Then select “RATE” and then press OK.
- A window will pop up.
- Input data in the required field.
- Final answer will be shown by the formula that is 14.87%
The rate of return is14.87%.
e.
To calculate: Time taken by 36.5 million populations to double with annual growth rate of 2%
Introduction:
Time Value of Money: It is a vital concept to the investors, as it suggests them the money they are having today is worth more than the value promised in the future.
e.

Explanation of Solution
Calculation is solved in spreadsheet by “NPER” formula
Table (5)
Steps required to calculate present value by using “NPER” function in excel are given,
- Select ‘Formulas’ option from Menu Bar of excel sheet.
- Select insert Function that is (fx).
- Choose category of Financial.
- Then select “NPER” and then press OK.
- A window will pop up.
- Input data in the required field.
- Final answer will be shown by the formula that is 35 years.
Conclusion:
It will take 35 years to double the population from 36.5 million to 73 million.
f.
To calculate: Present and future value of
Introduction:
Time Value of Money: It is a vital concept to the investors, as it suggests them the money they are having today is worth more than the value promised in the future.
f.

Explanation of Solution
Calculation in spreadsheet by “PV” formula,
Table (6)
Steps required to calculate present value by using “PV” function in excel are given,
- Select ‘Formulas’ option from Menu Bar of Excel sheet.
- Select insert Function that is (fx).
- Choose category of Financial.
- Then select “PV” and then press OK.
- A window will pop up.
- Input data in the required field.
- Final answer will be shown by the formula that is $3,352.16.
So, the present value is $3,352.16.
Calculation of future value of
Table (7)
Steps required to calculate present value by using “FV” function in excel are given,
- Select ‘Formulas’ option from Menu Bar of Excel sheet.
- Select insert Function that is (fx).
- Choose category of Financial.
- Then select “FV” and then press OK.
- A window will pop up.
- Input data in the required field.
- Final answer will be shown by the formula that is $6,742.38.
So the future value is $6,742.38.
Present value is $3,352.16 and future value is $6,742.38 of
g.
To calculate: Present and future value of part ‘f’ if the
Introduction:
Time Value of Money: It is a vital concept to the investors, as it suggests them the money they are having today is worth more than the value promised in the future.
g.

Explanation of Solution
Calculation in spreadsheet by “PV” function,
Table (8)
Steps required to calculate present value by using “PV” function in excel are given,
- Select ‘Formulas’ option from Menu Bar of Excel sheet.
- Select insert Function that is (fx).
- Choose category of Financial.
- Then select “PV” and then press OK.
- A window will pop up.
- Input data in the required field.
- Final answer will be shown by the formula that is $3,351.66.
Present value of
Future value of annuity in spreadsheet by “FV” function,
Table (9)
Steps required to calculate present value by using “FV” function in excel are given,
- Select ‘Formulas’ option from Menu Bar of Excel sheet.
- Select insert Function that is (fx).
- Choose category of Financial.
- Then select “FV” and then press OK.
- A window will pop up.
- Input data in the required field.
- Final answer will be shown by the formula that is $7,753.74
Future value of annuity due is $7,753.74.
Present value of
h.
To calculate: Present and future value for $1,000, due in 5 years with 10% semiannual compounding.
Introduction:
Time Value of Money: It is a vital concept to the investors, as it suggests them the money they are having today is worth more than the value promised in the future.
h.

Explanation of Solution
Calculation in spreadsheet by “PV” formula,
Table (10)
Steps required to calculate present value by using “PV” function in excel are given,
- Select ‘Formulas’ option from Menu Bar of Excel sheet.
- Select insert Function that is (fx).
- Choose category of Financial.
- Then select “PV” and then press OK.
- A window will pop up.
- Input data in the required field.
- Final answer will be shown by the formula that is $613.91.
Present value is $613.91.
Calculation in spreadsheet by “FV” formula,
Table (11)
Steps required to calculate present value by using “FV” function in excel are given,
- Select ‘Formulas’ option from Menu Bar of Excel sheet.
- Select insert Function that is (fx).
- Choose category of Financial.
- Then select “FV” and then press OK.
- A window will pop up.
- Input data in the required field.
- Final answer will be shown by the formula that is $1,628.89.
Future value of
Present andfuture value for $1,000, due in 5 years with 10% semiannual compoundingwill be $613.91 and $1,628.89, respectively.
i.
To calculate: Annual payments for an ordinary
Introduction:
Time Value of Money: It is a vital concept to the investors, as it suggests them the money they are having today is worth more than the value promised in the future.
i.

Explanation of Solution
Calculation in spreadsheet by “PMT” formula,
Table (12)
Steps required to calculate present value by using “PMT” function in excel are given,
- Select ‘Formulas’ option from Menu Bar of Excel sheet.
- Select insert Function that is (fx).
- Choose category of Financial.
- Then select “PMT” and then press OK.
- A window will pop up.
- Input data in the required field.
- Final answer will be shown by the formula that is $1,628.89.
Payment of ordinary
Calculation in spreadsheet by “PMT” formula,
Table (13)
Steps required to calculate present value by using “PMT” function in excel are given,
- Select ‘Formulas’ option from Menu Bar of Excel sheet.
- Select insert Function that is (fx).
- Choose category of Financial.
- Then select “PMT” and then press OK.
- A window will pop up.
- Input data in the required field.
- Final answer will be shown by the formula that is $1,628.89.
Payment of ordinary annuity due is $137.99.
Annual payments are$149.03 for an ordinary
j.
To calculate: Present value and future value of an investment that pays 8% annually and makes the year end payments of $100, $200,$300.
j.

Explanation of Solution
Calculation in spreadsheet by “
Table (14)
Steps required to calculate present value by using “NPV” function in excel are given,
- Select ‘Formulas’ option from Menu Bar of Excel sheet.
- Select insert Function that is (fx).
- Choose category of Financial.
- Then select “NPV” and then press OK.
- A window will pop up.
- Input data in the required field.
- Final answer will be shown by the formula that is $581.59.
Present value is $581.59.
Calculation in spreadsheet by “FV” formula,
Table (15)
Steps required to calculate present value by using “FV” function in excel are given,
- Select ‘Formulas’ option from Menu Bar of Excel sheet.
- Select insert Function that is (fx).
- Choose category of Financial.
- Then select “FV” and then press OK.
- A window will pop up.
- Input data in the required field.
- Final answer will be shown by the formula that is $732.54.
Future value is $732.54.
Present value is $581.89 while future value is $732.54.
k.1.
To calculate: Effective annual rate each bank pays and the future value of $5,000 at the end of 1 and 2 year.
k.1.

Explanation of Solution
Given for Bank A,
Nominal interest rate is 5%.
Compounding is annual.
Formula to calculate effective annual rate is,
Where,
- EFF is the effective annual rate.
- INOM is the nominal interest rate.
- M is the compounding period.
Substitute 5% for INOM and 1 for M.
So, effective annual rate for Bank A is 5%.
Given for Bank B,
Nominal interest rate is 5%.
Compounding is semiannual.
Formula to calculate effective annual rate is,
Where,
- EFF is the effective annual rate.
- INOM is the nominal interest rate.
- M is the compounding period.
Substitute 5% for INOM and 2 for M.
So,effective annual rate for Bank B is 5.06%.
Given for Bank C,
Nominal interest rate is 5%.
Compounding is quarterly.
Formula to calculate effective annual rate is,
Where,
- EFF is the effective annual rate.
- INOM is the nominal interest rate.
- M is the compounding period.
Substitute 5% for INOM and 4 for M.
So, effective annual rate for Bank C is 5.09%.
Given for Bank D,
Nominal interest rate is 5%.
Compounding ismonthly.
Formula to calculate effective annual rate is,
Where,
- EFF is the effective annual rate.
- INOM is the nominal interest rate.
- M is the compounding period.
Substitute 5% for INOM and 12 for M.
So, effective annual rate for Bank D is 5.11%.
Given for Bank E,
Nominal interest rate is 5%.
Compounding is daily.
Formula to calculate effective annual rate is,
Where,
- EFF is the effective annual rate.
- INOM is the nominal interest rate.
- M is the compounding period.
Substitute 5% for INOM and 365 for M.
So, effective annual rate for Bank E is 5.12%.
Calculation of future value in spreadsheet by “FV” formula,
Table (16)
Steps required to calculate present value by using “FV” function in excel are given,
- Select ‘Formulas’ option from Menu Bar of Excel sheet.
- Select insert Function that is (fx).
- Choose category of Financial.
- Then select “FV” and then press OK.
- A window will pop up.
- Input data in the required field.
So, the future value at different effective rate after a year are $5, 250, $5,253,$5,254.50, $5,255.50 and $5,256.
Calculation of future value in spreadsheet by “FV” formula,
Table (17)
Steps required to calculate present value by using “FV” function in excel are given,
- Select ‘Formulas’ option from Menu Bar of Excel sheet.
- Select insert Function that is (fx).
- Choose category of Financial.
- Then select “FV” and then press OK.
- A window will pop up.
- Input data in the required field.
So, the future value at different effective rate after a year are $5, 512, $5,518.80, $5,521.95, $5,524.06 and $5,525.11.
Each bank pays different effective rate as there compounding is different, the rates are5% for bank A, 5.06% Bank B, 5.09% Bank C, 5.11% Bank D, 5.12% Bank E, also the future values also change on the basis of their number of periods.
2.
To explain: If banks are insured by the government and are equally risky, will they be equally able to attract funds and at what nominal rate all banks provide equal effective rate as Bank A.
2.

Answer to Problem 41SP
No, it is not possible for the banks to equally attract funds.
The nominal rate which causes same effective rate for all banks are,
Particulars | A | B | C | D | E |
Nominalrate | 5% | 5.06% | 5.09% | 5.11% | 5.12% |
Table (18)
Explanation of Solution
- Bank will not be equally able to attract funds because of compounding, as people prefer to invest in that bank which have more frequent compounding in comparison to the bank which have lesser frequent compounding.
- Nominal rate is opposite of the effective rate which is calculated in part ‘1’. The nominal rate indicated in above table will cause same effective rate for all banks as it is for A bank.
Due to frequent compounding, banks will not be able to equally attract funds and the nominal rate will be 5% for Bank A, 5.06% Bank B, 5.09% Bank C, 5.11% Bank D, 5.12% Bank E.
3.
To calculate: Present value of amount to get $5,000 after 1 year.
3.

Explanation of Solution
Calculation of payment to be made in spreadsheet by “PMT” formula,
Table (19)
Steps required to calculate present value by using “PMT” function in excel are given,
- Select ‘Formulas’ option from Menu Bar of Excel sheet.
- Select insert Function that is (fx).
- Choose category of Financial.
- Then select “PMT” and then press OK.
- A window will pop up.
- Input data in the required field.
So, the amounts to be paid are$4,761.90,$2498.10,$1,102.40,$296.96 and $15.83.
4.
To explain: If all banks are providing a same effective interest rate would rational investor be indifferent between the banks.
4.

Answer to Problem 41SP
Yes, a rational investor would be indifferent between the banks.
Explanation of Solution
Rational investor chooses the bank which will provide him better return so he would be indifferent, if all the banks are giving same effective rate because he chooses the bank which will have more frequent compounding than others.
A bank offers frequent compounding is able to attract more number of customers than others.
To prepare: Amortization schedule to show annual payments, interest payments, principal payments, and beginning and ending loan balances.
Amortization:
Amotization means to write off or pay the debt over the priod of time it can be for loan or intangible assets. Its main purpose is to get cost recovery. Example of amortization is ,an automobile company that spent $20 million dollars on a design patent with a useful life of 20 years. The amortization value for that company will be $1 million each year.

Explanation of Solution
Calculation of annual installment is done by using “PMT” formula in spreadsheet at the amortization schedule.
Amortization schedule is prepared below,
Table (20)
Steps required to calculate present value by using “PMT” function in excel are given,
- Select ‘Formulas’ option from Menu Bar of Excel sheet.
- Select insert Function that is (fx).
- Choose category of Financial.
- Then select “PMT” and then press OK.
- A window will pop up.
- Input data in the required field.
Amortization schedule represents annual payments, interest payments, principal payments, and beginning and ending loan balances.
Want to see more full solutions like this?
Chapter 5 Solutions
FUND.OF FINANCIAL MGMT:CONCISE-MINDTAP
- Question 6 A five-year $50,000 endowment insurance for (60) has $1,000 underwriting expenses, 25% of the first premium is commission for the agent of record and renewal expenses are 5% of subsequent premiums. Write the gross future loss random variable: Presuming a portfolio of 10,000 identical and independent policies, the expected loss and the variance of the loss of the portfolio are given below (note that the premium basis is not given or needed): E[L] = 10,000(36,956.49 - 3.8786P) V[L] 10,000 (50,000 + 14.52P)². 0.00095 Find the premium that results in a 97.5% probability of profit (i.e. ¹ (0.975) = 1.96). Premium: Please show your work belowarrow_forwardWhat corporate finance?? can you explain this? fully no aiarrow_forwardWhat is corporate finance? how this is usefull?arrow_forward
- Pam and Jim are saving money for their two children who they plan to send to university.The eldest child will enter university in 5 years while the younger will enter in 7 years. Each child is expected spend four years at university. University fees are currently R20 000 per year and are expected to grow at 5% per year. These fees are paid at the beginning of each year.Pam and Jim currently have R40 000 in their savings and their plan is to save a fixed amount each year for the next 5 years. The first deposit taking place at the end of the current year and the last deposit at the date the first university fees are paid.Pam and Jim expect to earn 10% per year on their investments.What amount should they invest each year to meet the cost of their children’s university fees?arrow_forwardPam and Jim are saving money for their two children who they plan to send to university.The eldest child will enter university in 5 years while the younger will enter in 7 years. Each child is expected spend four years at university. University fees are currently R20 000 per year and are expected to grow at 5% per year. These fees are paid at the beginning of each year.Pam and Jim currently have R40 000 in their savings and their plan is to save a fixed amount each year for the next 5 years. The first deposit taking place at the end of the current year and the last deposit at the date the first university fees are paid.Pam and Jim expect to earn 10% per year on their investments.What amount should they invest each year to meet the cost of their children’s university fees?arrow_forwardYou make a loan of R100 000, with annual payments being made at the end of each year for the next 5 years at a 10% interest rate. How much interest is paid in the second year?arrow_forward
- Dr Z. Mthembu is the owner of Mr Granite, a business in the Western Cape. After more than 28 years of operation, the business is thinking about taking on a new project that would provide a profitable new clientele. With only R1.5 million in resources, the company is now working on two competing projects. The starting costs for Project X and Project Y are R625,000 and R600000, respectively. These projected are estimated for the next 7 years timeframe. According to SARS, the tax rate is 28%, and a discount rate of 11.25% is applied.Projects X Project YProject X Project Y129000 145000154000 145000312000 145000168000 14500098250 14500088750 14500016050 145000arrow_forwardDr Z. Mthembu is the owner of Mr Granite, a business in the Western Cape. After more than 28 years of operation, the business is thinking about taking on a new project that would provide a profitable new clientele. With only R1.5 million in resources, the company is now working on two competing projects. The starting costs for Project X and Project Y are R625,000 and R600000, respectively. These projected are estimated for the next 7 years timeframe. According to SARS, the tax rate is 28%, and a discount rate of 11.25% is applied.Projects X Project YProject X Project Y129000 145000154000 145000312000 145000168000 14500098250 14500088750 14500016050 145000arrow_forwardDr Z. Mthembu is the owner of Mr Granite, a business in the Western Cape. After more than 28 years of operation, the business is thinking about taking on a new project that would provide a profitable new clientele. With only R1.5 million in resources, the company is now working on two competing projects. The starting costs for Project X and Project Y are R625,000 and R600000, respectively. These projected are estimated for the next 7 years timeframe. According to SARS, the tax rate is 28%, and a discount rate of 11.25% is applied.Projects X Project YProject X Project Y129000 145000154000 145000312000 145000168000 14500098250 14500088750 14500016050 145000arrow_forward
- Dr Z. Mthembu is the owner of Mr Granite, a business in the Western Cape. After more than 28 years of operation, the business is thinking about taking on a new project that would provide a profitable new clientele. With only R1.5 million in resources, the company is now working on two competing projects. The starting costs for Project X and Project Y are R625,000 and R600000, respectively. These projected are estimated for the next 7 years timeframe. According to SARS, the tax rate is 28%, and a discount rate of 11.25% is applied.Projects X Project YProject X Project Y129000 145000154000 145000312000 145000168000 14500098250 14500088750 14500016050 145000arrow_forwardAn investor buys 100 shares of a $40 stock that pays an annual cash dividend of $2 a share (a 5 percent dividend yield) and signs up for the DRIP. a. If neither the dividend nor the price changes, how many shares will the investor have at the end of 10 years? How much will the position in the stock be worth? Answer: 5.000 shares purchased in year 1 5.250 shares purchased in year 2 6.078 shares purchased in year 5 62.889 total shares purchased b. If the price of the stock rises by 6 percent annually but the dividend remains at $2 a share, how many shares are purchased each year for the next 10 years? How much is the total position worth at the end of 10 years? Answer: 4.717 shares purchased in year 1 4.592 shares in year 3 3.898 shares in year 10 Value of position: $10,280 c. If the price of the stock rises by 6 percent annually but the dividend rises by only 3 percent annually, how many shares are purchased each year for the next 10 years? How much is the total position worth at the…arrow_forwardDr Z. Mthembu is the owner of Mr Granite, a business in the Western Cape. After more than 28 years of operation, the business is thinking about taking on a new project that would provide a profitable new clientele. With only R1.5 million in resources, the company is now working on two competing projects. The starting costs for Project X and Project Y are R625,000 and R600000, respectively. These projected are estimated for the next 7 years timeframe. According to SARS, the tax rate is 28%, and a discount rate of 11.25% is applied.Projects X Project YProject X Project Y129000 145000154000 145000312000 145000168000 14500098250 14500088750 14500016050 145000 Calculate the IRR for the two proposed Projectsarrow_forward
- Essentials Of InvestmentsFinanceISBN:9781260013924Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.Publisher:Mcgraw-hill Education,
- Foundations Of FinanceFinanceISBN:9780134897264Author:KEOWN, Arthur J., Martin, John D., PETTY, J. WilliamPublisher:Pearson,Fundamentals of Financial Management (MindTap Cou...FinanceISBN:9781337395250Author:Eugene F. Brigham, Joel F. HoustonPublisher:Cengage LearningCorporate Finance (The Mcgraw-hill/Irwin Series i...FinanceISBN:9780077861759Author:Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan ProfessorPublisher:McGraw-Hill Education





