Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Roger and Wanda Person are average folks who want to live the good life. They meet at CMC during college and later decide to get

Roger  and Wanda Person are average folks who want to live "the good life."  They meet at CMC during college and later  decide to get married, raise a family, buy a house, and save for their son's  college and their retirement.  What will  it take for them to manage to pay their expenses, plan ahead for unexpected  events, and save enough money to enjoy their retirement years?  This case study helps you think about  financial planning over a long period of time.

continues in the attachment 

Roger & Wanda Anybody: BASE CASE FINANCIAL PROJECTION Life Events and Financial Conditions Year Events SALARY Begin Principal 2021 175000.00 Year Interest Amortization -619.79 619.79 End Principal 174380.21 4.25% APR Case Study #1 Life Cycle (Time Value of Money) Analysis: The PersonsRoger and Wanda Person are average folks who want to live "the good life." They meet at CMC during college  2015 2017 2021 2022 2024 At age 22 we met and graduated from CMC with BSBA degrees. We each started work and Roger then told you the following assumptions he has about their future finances: 2027 Wanda continues to get Roger asks you to prepare a financial plan to help him and Wanda understand their finances as they plan ahead QUESTIONS What do you think of the Persons' life savings plan? Do you think they will be able to enjoy a good Add an appendix to your report. In the appendix, discuss what YOU as real persons learned from this exercise RECOMMENDED WORK PLAN: Appoint one team member to create the calculations in Excel for your case study. GROUP CASE #1 CHECKLIST 2015 Wanda and Roger initial salary $39,000 2015 Wanda and Roger annual savings 10% 2029 Roger salary increase 2035 Roger health problems 2042-2045 Savings reduction to pay for Turner's college Calculate, and determine what year the savings runs out, in the initial case study Recalculate savings if 

Roger & Wanda Anybody: BASE CASE FINANCIAL PROJECTION Life Events and Financial Conditions Year Events SALARY & OTHER INCOME REDUCTIONS FROM INCOME Roger Wanda Wedding Mortgage Turner Other Year's Savings Savings Balance and Calculations Beginning of Year Retirement Savings TOTAL Investments Bank Bank Interest Invest Earnings Year Savings 1% 6% (Col. J) End of Year Retirement Savings Bank TOTAL Investments

Step by Step Solution

3.55 Rating (159 Votes )

There are 3 Steps involved in it

Step: 1

ase Wanda 75000 60000 0 89250 4000 0 9500 80100 25000 55100 0 2406 2406 93600 25000 40100 2033 40 continued working 75000 60000 0 89250 4000 0 9500 93600 25000 68600 0 3216 3216 107100 25000 53600 203... 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

Step: 3

blur-text-image

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

Principles of economics

Authors: N. Gregory Mankiw

6th Edition

978-0538453059, 9781435462120, 538453052, 1435462122, 978-0538453042

More Books

Students also viewed these Banking questions

Question

Draw a schematic diagram of I.C. engines and name the parts.

Answered: 1 week ago