Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Each of the following items are separate calculations. You will end up with three spreadsheets the original ( Item 1 below ) , one for

Each of the following items are separate calculations. You will end up with three spreadsheets the original (Item 1 below), one for Item 2 below and one for Item 3 below. Use formulas when possible and do not make manual entries of calculation results. For example, if you are to enter the future value of an amount, be sure to use the FV formula in Excel (doing the calculation on a calculator and then entering the results is NOT acceptable)1. Ben and Karen want to know the true cost of financing college using their retirement plans (under the current plan we have done in class).a. OUTPUT: List (describe) the items you considered for this calculation and show your calculation in the education tab). Hint: be sure to think outside the box on topics like opportunity costs.b.50 points 2. Ben and Karen want to know the earliest they can retire, without considering the use of 401(k) funds to cover college costs. For this calculation, they want to consider using an average of the two projected social security benefits used in the original plan.a. OUTPUT: Retirement Capital tab, Retire SSAve$ tabb. 100 points 3. Ben and Karen want to understand the consequences of changing the current education goal from $35,000 in the future to the future value of $35,000. What will be the new required savings rate? How will this impact the Capital Needs Analysis of Ben and Karen? How will this impact the retirement capital should they decide to fund college with their 401(k) plans?a. OUTPUT: College Funding tab, CNA Karen tab, CNA Ben tab, Retire Capital with College tabb. 250 poInts
I need an excel spreadsheet formulas with separate tabs

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Psychology Of Trading Tools And Techniques For Minding The Markets

Authors: Brett N. Steenbarger

1st Edition

0471267619, 9780471267614

More Books

Students also viewed these Finance questions

Question

Describe the major barriers to the use of positive reinforcement.

Answered: 1 week ago