# Solved How do I caculate a 401k plan in excel?

December 12, 2015 at 05:51:24
Specs: Windows 7
 I'm trying to calculate a 401k plan that shows 40 cents on the dollar up to 8%. How do I do that in MS Excel? See More: How do I caculate a 401k plan in excel?

#1 December 12, 2015 at 05:57:49
 I don't understand what you are asking. 40 cents on a dollar is 40%. What does "up to 8% mean"?What does "calculate a 401k plan" mean?

Report •

#2
December 12, 2015 at 06:06:28
 I'm trying to calculate 40 cents for every dollar up to 8% in excel. For an example, my 401k plan matches up salary dollar for dollar up to 6%, but if it's only 40 cents of a dollar, how is that entered into excel? To calculate my example, I would enter 0.06*(Salary amount) How does one have excel calculate 40 cents on a dollar?

Report •

#3 December 12, 2015 at 09:48:35
✔ Best Answer
 Is this what your looking for:``` A B 1) Salary \$100,000.00 2) Percent Match 8% 3) Dollar Amt \$8,000.00 4) 5) 40 Cents 40% 6) Total Match \$3,200.00 ```In Excel the formula would be:=(40%*8%)*B1Does that work for you?MIKEhttp://www.skeptic.com/

Report •
Related Solutions
{"ft_lang_label":"__label__en","ft_lang_prob":0.89762306,"math_prob":0.535858,"size":862,"snap":"2019-13-2019-22","text_gpt3_token_len":264,"char_repetition_ratio":0.14219114,"word_repetition_ratio":0.0,"special_character_ratio":0.34106728,"punctuation_ratio":0.1182266,"nsfw_num_words":0,"has_unicode_error":false,"math_prob_llama3":0.9707697,"pos_list":[0,1,2,3,4,5,6,7,8],"im_url_duplicate_count":[null,null,null,null,null,null,null,null,null],"WARC_HEADER":"{\"WARC-Type\":\"response\",\"WARC-Date\":\"2019-05-27T01:27:36Z\",\"WARC-Record-ID\":\"<urn:uuid:bc8d848a-ff3c-4f36-9eac-2f43e55f2105>\",\"Content-Length\":\"33261\",\"Content-Type\":\"application/http; msgtype=response\",\"WARC-Warcinfo-ID\":\"<urn:uuid:1c8d29ea-0614-4387-bf9f-6959d1eda0f6>\",\"WARC-Concurrent-To\":\"<urn:uuid:c29e48b5-b40e-43fc-b7c4-9255c79081de>\",\"WARC-IP-Address\":\"67.227.213.68\",\"WARC-Target-URI\":\"https://www.computing.net/answers/office/how-do-i-caculate-a-401k-plan-in-excel/20126.html\",\"WARC-Payload-Digest\":\"sha1:ZBWY3EM5IXKYSUUOW52H6GU4435AVWDX\",\"WARC-Block-Digest\":\"sha1:NPJ477VYGU4VD63Q27LHF7QHYRNELZLU\",\"WARC-Identified-Payload-Type\":\"application/xhtml+xml\",\"warc_filename\":\"/cc_download/warc_2019/CC-MAIN-2019-22/CC-MAIN-2019-22_segments_1558232260358.69_warc_CC-MAIN-20190527005538-20190527031538-00133.warc.gz\"}"}