Jerry is an extremely hard worker, so every year he earns a bonus of $10,000 at his job for his efforts. Over a career of 35 years, what is the present worth of all his bonuses from the point of view of the employer if the interest rate is 8%? Use an EXCEL function to determine the answer. Choose the closest answer you would get if you used an EXCEL function.

$116,545.68  

Explanation:

We have to find the Present value by applying the Present value formula that is shown on the excel attachment

Data provided in the question

Future value = $0

Rate of interest = 8%

NPER = 35 years

PMT = $10,000

The formula is shown below:

= -PV(Rate,NPER,PMT,FV,type)

So, after solving this, the present worth is $116,545.68  

b. take periodic breaks and alternate between tasks.  

will increase work efficiency, and avoid health issues.

since the options are not listed, when you are working on your budget you should also add water, tv, internet, miscellaneous and your 'fun' money for in your budget. when budgeting, you need to allow for fun money, and mis/accidental money so that you stick to the budget and not go crazy because you feel strapped to the budget.