Make an Excel model for a superannuation account. For simplicity, assume the rate is (2%) Make...

Make an Excel model for a superannuation account. For simplicity, assume the rate is (2%)

Make the following inputs.

a. Age (an integer)

c. Desired superannuation withdrawal amount (in dollars)

d. Desired annual income for ages 65 to 85, inclusive (males), Assume this annual amount is paid on each birthday, starting at age 65, and ending at 85. This stream of annual payments is what we refer to below as the user’s retirement income stream.

The spreadsheet will then generate the following outputs.

a. The reduction in the user’s retirement income stream by making the above withdrawal from the user’s superannuation fund. This retirement income stream refers to constant annual payments made at ages 65 to 85, inclusive.

b. The lump sum required (today) at the user’s current (integer) age to generate the desired annual retirement income stream inputted.

Solutions

Expert Solution

As it also requires several other inputs, made input cells for that as well, use accordingly.

Formulae are below.

Good Luck

jeff jeffy answered 1 year ago

Next > < Previous

Related Solutions

Kiran is 22 today and his superannuation account contains exactly $10,000. Assume this balance will earn...

Kiran is 22 today and his superannuation account contains exactly $10,000. Assume this balance will earn an average return rate of 6% p.a. compounding semi-annually until his retirement at age 65. Calculate the investment returns (in dollars) this sum will earn in the final year before retirement.

A) Assume that you wish to make annual deposits into a savings account. The interest rate...

A) Assume that you wish to make annual deposits into a savings account. The interest rate offered by the bank is 11%, and you plan to save for the next 12 years. If your goal is for the present value of your savings to be equal to $4,058, how much money must you deposit every year? B) Assume you've just received a bonus at work of $3,812. You deposit that money in the bank today, where it will earn interest...

SOLVE IN EXCEL Sondra deposits $5,500 in an IRA account on April 15, 2019. Assume the...

*SOLVE IN EXCEL* Sondra deposits $5,500 in an IRA account on April 15, 2019. Assume the account will earn 3% annually. If she repeats this for the next nineteen years (for a total of twenty contributions), how much will she have on deposit on April 14, 2039?

The price of a serving of McDonald's French fries in 1950 was 10c For simplicity, assume...

The price of a serving of McDonald's French fries in 1950 was 10c For simplicity, assume the price of a serving of McDonald's French fries today is $1.67, the CPI for 1950 is 23.5 and the CPI for today is 240.5. In terms of today's dollars, the real price of McDonald's French fries in 1950 was S. (Enter your response rounded to two decimal places)

Suppose that Bob produces electric bikes in a competitive market. For simplicity, assume that there are...

Suppose that Bob produces electric bikes in a competitive market. For simplicity, assume that there are no fixed costs to produce e-bikes. Illustrate two graphs side by side. On left- hand side graph, present the firm. On the right-hand side graph, present the corresponding market. For the firm draw a smooth U-shaped average cost curve and a corresponding marginal cost curve. For the market, draw a demand curve and short-run supply curve that provides positive economic profit for the firm....

Ignore, for simplicity, the possibility of being born on February 29th. Assume that a person is...

Ignore, for simplicity, the possibility of being born on February 29th. Assume that a person is just as likely to be born on any one date as on any other date, excluding February 29th, of course. Suppose 253 people are picked at random. (We use 253 since e” = 1/2 almost exactly. Use 1/2 in your computations.) a. What is the expected number of different birthdays of the group? b. The expected number of days which are each the birthday of...

Consider a Ricardian model where there are two goods: apples and bananas. For simplicity we will...

Consider a Ricardian model where there are two goods: apples and bananas. For simplicity we will only consider one country called Alba (that is we will not think about its trading partner (or potential trading partner)). In Alba the unit labour requirement for an apple is 20 hours and for a banana is 10 hours. Alba has an endowment of 1000 hours of labour. Draw a production possibility frontier (PPF) diagram for Alba. Apples must be on the vertical axis...

Ken planned to make monthly deposits in to a saving account at a nominal rate of...

Ken planned to make monthly deposits in to a saving account at a nominal rate of 3% compounded monthly for 180 months. The amount of deposit is k at the end of the k th month, where k = 1, 2, ..., 180. However, he was unemployed for a short period of time, so he missed the 1st through 9th payments. He made the rest of the payments as planned. How much does Ken have in his saving account at...

A) Consider a portfolio of cancer research projects, and assume for simplicity that each project's financial...

A) Consider a portfolio of cancer research projects, and assume for simplicity that each project's financial return has a standard deviation of 400%. If the correlation coefficient between each pair of projects is 0.5, what is the standard deviation of an equal-weighted portfolio of: (Note: Your answer should be a number in percentage form. Do not enter '%'.) 10 projects? ____% 100 projects ___% 1000 projects ____% B) Now assume the projects are statistically independent and therefore uncorrelated. What is...

You have learned that money velocity is rather stable. Assume for simplicity that the velocity is...

You have learned that money velocity is rather stable. Assume for simplicity that the velocity is constant (the quantity theory of money). Explain how the growth in the money supply and inflation are related.

Subjects