Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I am looking for a formula or how to calculate the on the excel the retirement need to cover yearly withdrawals and retirement need to

I am looking for a formula or how to calculate the on the excel the "retirement need to cover yearly withdrawals" and "retirement need to cover charitable donations". I dont think I did this correct at all. image text in transcribed
CHAPTER 3, ACTIVITY 3: RETIREMENT CALCULATOR INPUTS: Current Age Retirement Age Amount Saved So Far Current Income Income Growth Rate Savings Rate $2,000 $58,000 3.80% 20.00% 7.00% $288,346.17 $4,884,353.71 APR MAX INCOME PRE-RETIREMENT FV OF SAVINGS 60% $173,007.70 2.30% 4.00% RETIREMENT: % of max income required Amount Needed in First Year of Retirement Annual Growth Rate Retirement APR Retirement Years PLANNED LEGACY DONATION RETIREMENT NEED TO COVER YEARLY WITHDRAWALS RETIREMENT NEED TO COVER CHARITABLE DONASAN TOTAL RETIREMENT NEED $500,000 $64,898.10 $64,898.10 $3,574,175.01 WILL YOU REACH GOAL? CHAPTER 3, ACTIVITY 3: RETIREMENT CALCULATOR INPUTS: Current Age Retirement Age Amount Saved So Far Current Income Income Growth Rate Savings Rate $2,000 $58,000 3.80% 20.00% 7.00% $288,346.17 $4,884,353.71 APR MAX INCOME PRE-RETIREMENT FV OF SAVINGS 60% $173,007.70 2.30% 4.00% RETIREMENT: % of max income required Amount Needed in First Year of Retirement Annual Growth Rate Retirement APR Retirement Years PLANNED LEGACY DONATION RETIREMENT NEED TO COVER YEARLY WITHDRAWALS RETIREMENT NEED TO COVER CHARITABLE DONASAN TOTAL RETIREMENT NEED $500,000 $64,898.10 $64,898.10 $3,574,175.01 WILL YOU REACH GOAL

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

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

Advanced Level Audit And Assurance Exam Room Notes 2017

Authors: ACA Simplified

1st Edition

1545501653, 978-1545501658

More Books

Students also viewed these Accounting questions