Question

In: Finance

THE FOLLOWING DATA APPLY TO THE NEXT THREE PROBLEMS Johnny and Ronny have both been given...

THE FOLLOWING DATA APPLY TO THE NEXT THREE PROBLEMS Johnny and Ronny have both been given $50,000 by their grandparents today on their 21st birthdays. They want to save for their future and have aspirations of one day being millionaires. Both boys plan to make annual contributions on their birthday, beginning next year. Johnny and Ronny have each opened investment accounts at Chase and Wells Fargo, respectively, and they expect to earn nominal returns of 8% and 9% respectively. Johnny has already decided to deposit $8,000 each year into his investment account, while Ronny is unsure of the amount he will deposit annually.

How many years will it take Johnny before he reaches his investment goal of $1 million?

If Ronny decides to make the same annual contributions as Tommy, how much sooner (in years) would he reach the investment goal?

Suppose Ronny was interested in reaching the investment goal at the same time as Johnny. What is the minimum monthly contribution he could make to reach $1 million at the same time as Johnny?

Solutions

Expert Solution

Value of saving at age of 21 year = $50,000.

Return on investment for Johnny = 8%

Return on investment for Ronny = 9%.

a.

Annual Investment by Johnny = $8,000

Number of year it will take to become millionaires is calculated in excel and screen shot provided below:

It will take 26 year for Johnny to become millionaire.

b.

If Ronny decides to make the same annual contributions as Johnny then Number of year it will take to become millionaires is calculated in excel and screen shot provided below:

For Ronny it will take 24 year to become millionaire.

c.

for Johnny it will take 26 year

Future value of current saving at 9% = $50,000 × (1 + 9%) ^ 26

= $50,000 × 9.3095

= $465,476.42.

Future value of current saving at 9% is $465,476.42.

Excess amount required through monthly Saving = $1,000,000 - $465,476.42

= $534,523.58.

Excess amount required through monthly Saving is $534,523.58.

Minimum monthly contribution he could make to reach $1 million at the same time as Johnny is calculated in excel and screen shot provided below:

Value of monthly Saving is $436.28.


Related Solutions

The following data apply to the next three questions.          You have been asked to evaluate...
The following data apply to the next three questions.          You have been asked to evaluate the proposed acquisition of a new machine to expand your company’s product line. The machine’s purchase price is $740,000. It would be depreciated straight-line, down to zero, over four years. Purchase of the machine would require an increase in net working capital of $100,000. The machine would generate $400,000 before-tax revenues per year but would have operating costs of $150,000 per year. The machine...
The following data apply to this and the next two problems. The Global Advertising Company had...
The following data apply to this and the next two problems. The Global Advertising Company had net income after interest but before taxes of $50,000 this year. The marginal tax rate is 34%, and the dividend payout ratio is 45%. The company can raise debt at a 12 percent interest rate for any amount of debt less than $8,000. If the firm raises more than $8,000 of debt, a 15 percent interest rate will apply. The last dividend paid by...
Q3.15You have been given the following return data on three assets: F, G and H and...
Q3.15You have been given the following return data on three assets: F, G and H and the two portfolios – over the period 2013 to 2016: Year Asset F Asset G Asset H Portfolio FG Portfolio FH 2013 16 17 14 16.5 15 2014 17 16 15 16.5 16 2015 18 15 16 16.5 17 2016 19 14 17 16.5 18 Using these assets, you have isolated three investment alternatives: 100% of Asset F   50% of Asset F and 50%...
You have been given the expected return data shown in the first table on the three...
You have been given the expected return data shown in the first table on the three assets - F, G, and H - over the period 2016-2019 Expected Return Expected Return Expected Return Year Asset F Asset G Asset H 2016 16% 17% 14% 2017 17 16 15 2018 18 15 16 2019 19 14 17 Using these assets, you have isolated the three investment alternatives shown in the following table. Alternative Investment 1 100% of asset F 2 50%...
Use the following information for the next three problems.  Suppose that  = 30% of the students at a...
Use the following information for the next three problems.  Suppose that  = 30% of the students at a large university must take a statistics course.  Suppose that a random sample of 50 students is selected.  Let  = the percent of students in the sample who must take statistics. Different samples will produce different values of .  In order for the values of  to vary according to a normal model, we need to check two conditions.  Which two of the following need to be checked? a. The sample size  is...
Use the following information for the next three problems.  Suppose that  = 30% of the students at a...
Use the following information for the next three problems.  Suppose that  = 30% of the students at a large university must take a statistics course.  Suppose that a random sample of 50 students is selected.  Let  = the percent of students in the sample who must take statistics. Different samples will produce different values of .  In order for the values of  to vary according to a normal model, we need to check two conditions.  Which two of the following need to be checked? a. and b. The...
You have been given the balance sheet (next page) for Roxbury Savings Bank and have been...
You have been given the balance sheet (next page) for Roxbury Savings Bank and have been asked for your assessment of its capital adequacy. You have been told it has no off-balance sheet activities. What is its: Tier 1 capital? Tier 1 and 2 capital? Risk-weighted assets? (You can put your answer on the next page with the balance sheet.) Ratio of Tier 1 capital to its i) total assets and ii) total risk-weighted assets? Ratio of Tier 1 and...
Portfolio analysis You have been given the return data shown in the first table on three...
Portfolio analysis You have been given the return data shown in the first table on three assets—F, G, and H—over the period 2010–2013. Expected return Year Asset F Asset G Asset H 2010 16% 17% 14% 2011 17% 16% 15% 2012 18% 15% 16% 2013 19% 14% 17% Using these assets, you have isolated the three investment alternatives shown in the following table: Alternative Investment 1 100% of asset F 2 50% of asset F and 50% of asset G...
You have been given the expected return data shown in the first table on three assetslong...
You have been given the expected return data shown in the first table on three assetslong dash—​F, ​G, and Hlong dash—over the period​ 2016-2019: lick on the icon located on the​ top-right corner of the data table below in order to copy its contents into a​ spreadsheet.) Expected Return Year Asset F Asset G Asset H 2016 11​% 12%     9​%     2017 12​% 11% 10​% 2018 13% 10​% 11​% 2019 14​% 99% 12​% . Using these​ assets, you have isolated the...
you have been given the expected return data shown in the first table on three assetslong...
you have been given the expected return data shown in the first table on three assetslong dash—​F, ​G, and H long dash—over the period​ 2016-2019: Expected Return Year Asset F Asset G Asset H 2016 16​% 17​%     14​%     2017 17​% 16​% 15​% 2018 18​% 15​% 16​% 2019 19​% 14​% 17​% Using these​ assets, you have isolated the three investment alternatives shown in the following​ table Alternative Investment 1 ​100% of asset F 2 ​50% of asset F and​ 50% of...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT