2/9/2021 Thread: Week 4 DB – 2021SP-12693-FINC3304-Business Finance...

1 answer below »
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:
Answered 2 days AfterFeb 09, 2021

Answer To: 2/9/2021 Thread: Week 4 DB – 2021SP-12693-FINC3304-Business Finance...

Himanshu answered on Feb 12 2021
80 Votes
CH 5 Questions {35-45}
    35                Years        Interest Rate
        Salary 1    $ 6,100.00    Per Month    2        7%
        Sala
ry 2    $ 5,100.00    Per Month    2    $ 25,000.00    7%
        Compounded Monthly
        Salary 1    N    24
        Salary 2    N    24
            Rate    0.58%
        Salary 1    Pv ordinary Annuity        C*((1-(1+i)^-n))/i        $ 136,244.11
        Salary 2    Pv ordinary Annuity        C*((1-(1+i)^-n))/i        $ 113,909.01    $ 138,909.01    Note: As it is mentioned $5,100 per month along with $25,000 signing bonus today
            Clearly , we prefer Option 2nd
    36        PMT    $ 22,500.00
            N    20
            Rate    8%
            FV    $ - 0
            PV    $ -220,908.32
    37        InvG    InvH
        Upfront cost    $ 30,000.00    $ ...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here