There are 2 different assignments attached. The first is a discussion assignment please follow instructions on the discussion the solution for the discussion will need to be done on WORD Doc for this discussion assume my age is 25 and 11 months. The second assignment is homework based on 3 chapters. The homework will need to be done on the attached EXCEL. Each chapter has to be done on a different tab as set up on the excel.
2/9/2021 Thread: Week 4 DB – 2021SP-12693-FINC3304-Business Finance https://elearning.uhv.edu/webapps/discussionboard/do/message?action=list_messages&course_id=_143961_1&nav=discussion_board_entry&conf_id… 1/3 Thread: Week 4 DB2021SP-12693-FINC3304-Business Finance Discussion Board Forum: Week 4 DB Thread: Week 4 DB 1 Post(s) in this Thread 0 Unread 0 Unread Replies to Me Select: All None Message Actions Expand All Collapse All Week 4 DB 2 days agoMassoud Metghalchi 1. Assume you drink one co�ee per day, 5 days a week. Assume co�ee price is $4.00. That makes it $20 per week and $80 per month. Assume you can invest $80 per month in the stock market and assume you can earn 1 % per month on your stock investment or 12 % per year. Time Value of Money THIS DISCUSSION BOARD REMAINS ACTIVE TILL From 2/8 to 2/14 Each student should answer question 1 &2. Answer to the question 1 is related to your actual age. Simplify your age to the month, if for example your age is 20 years 1 month and 19 days, use 20 years and 2 months. If your age is 34 years and one month and 3 days, use 34 years and one month, in other words, bring your age to closest month. IMPORTANT NOTE: When answering a question, copy the whole question (Don’t write Q1 or Q2) so that another student see your answer, he or she can relate the answer to the question. A: At your retirement, when you are 65 years old, how much you will have in your retirement account if you switch from co�ee drinking to investing in the stock market? B. Assume that when you get to 65 (retirement age) you switch your funds from stock market investment to bond market investment. Assume you can earn 7% on your bond investment. You decide to withdraw a constant amount each year for the next 20 years when you get to retirement age of 65. How much will be your annual withdrawal from age 66 to 85 (Nothing left at 85) if you switch your co�ee drinking to stock and bond investments. ? My UHV Courses UHV Content Collection UHV Blackboard Help UHV Course Evals UHV Services Monica Bonner 57 https://elearning.uhv.edu/webapps/blackboard/execute/courseMain?course_id=_143961_1 https://elearning.uhv.edu/webapps/discussionboard/do/conference?toggle_mode=read&action=list_forums&course_id=_143961_1&nav=discussion_board_entry https://elearning.uhv.edu/webapps/discussionboard/do/forum?action=list_threads&forum_id=_671412_1&conf_id=_371563_1&course_id=_143961_1&nav=discussion_board_entry javascript:expandAllMessagesInTheTree(); javascript:collapseAllMessagesInTheTree(); https://elearning.uhv.edu/webapps/portal/execute/tabs/tabAction?tab_tab_group_id=_21_1 https://elearning.uhv.edu/webapps/portal/execute/tabs/tabAction?tab_tab_group_id=_23_1 https://elearning.uhv.edu/webapps/portal/execute/tabs/tabAction?tab_tab_group_id=_41_1 https://elearning.uhv.edu/webapps/portal/execute/tabs/tabAction?tab_tab_group_id=_24_1 https://elearning.uhv.edu/webapps/portal/execute/tabs/tabAction?tab_tab_group_id=_25_1 https://elearning.uhv.edu/webapps/login/?action=logout 2/9/2021 Thread: Week 4 DB – 2021SP-12693-FINC3304-Business Finance https://elearning.uhv.edu/webapps/discussionboard/do/message?action=list_messages&course_id=_143961_1&nav=discussion_board_entry&conf_id… 2/3 2. Given your age, and assume average stock market return is 10% per year compounded monthly; how much per month you should save (In IRA or 401 K, or other tax defer retirement accounts) to accumulate $1,000,000.00 when you get to 67 retirement age? I start �rst answer Q1 so that you can see the format: Assume I am 54 and I retire at age 68, how much will be the total amount of money in my account if I switch from co�ee drinking to investing in the stock market? B) How much a can withdraw per year after I get 68 years old, for 20 years? ANSWER: Assume I am 54 years old and will retire at age 68: Retire in 14 years at age 68. Excel 1.a Inputs Interest 1.00% Period 168 (14*12) Payment 80 FV ($34,567.76) FV(B7,B8,B9,0,0); B7,B8,B9=1%,168,80 1.b inputs Interest 7.00% Period 20 PV ($34,567.76) PMT $3,262.95 PMT(B16,B17,B18,0,0) B16,B17,B18=7%,20, (34567) 2/9/2021 Thread: Week 4 DB – 2021SP-12693-FINC3304-Business Finance https://elearning.uhv.edu/webapps/discussionboard/do/message?action=list_messages&course_id=_143961_1&nav=discussion_board_entry&conf_id… 3/3 Select: Reply Mathematical Formula 1.a (1 + i)n = 5.32096982 (1 + i)n -1 = 4.32096982 [(1 + i)n -1]/i = 432.096982 PMT[(1 + i)n -1]/i = $34,567.76 1.b (1 + i)n = 3.86968446 1/(1 + i)n = 0.258419 [1-1/(1 + i)n] = 0.741581 [1-1/(1 + i)n]/i = 10.5940142 PV = $34,567.76 PMT = $3,262.95 All None Message Actions Expand All Collapse All ← OK javascript:Message.editOrReplyMessage( '_10885301_1', replyUrl+'_10885301_1', $('_10885301_1') ) javascript:expandAllMessagesInTheTree(); javascript:collapseAllMessagesInTheTree(); https://elearning.uhv.edu/webapps/discussionboard/do/forum?action=list_threads&course_id=_143961_1&conf_id=_371563_1&forum_id=_671412_1&message_id=_10885301_1&nav=discussion_board_entry&nav=discussion_board_entry chapter 5 homework problems assigned CHAPTER 6 CHAPTER 7: