Please download the attached Excel file, complete it according to the instructions, rename it using your last_name and HWCh4 (example: MaskaraHWCh4.xls) and then resubmit it as your homework solution.
Questions 1 through 4 require you to type in the Excel built-in formulas to calculate the answer for each problem. Examples of the Excel formulas are included in the PDF of the video lectures for TVM-Future Value and TVM-Present Value. The Excel formulas must be entered into the Excel cells highlighted in light blue. The formula must reference a cell. You cannot hardcode numbers. If you do not understand what hardcode means, watch the recording of the zoom lecture from this week before doing this assignment.
Question 5 is primarily an Excel functionality exercise. Complete the missing items in the table that are highlighted in light blue. The purpose of this exercise is to illustrate how to use the Excel built-in TVM functions and also how to calculate the same results using the equivalent algebraic formula. The exercise can be completed in a few seconds (Yes, seconds, not minutes) by appropriately copying the formulas from the portions of the table already filled in. If you are not familiar with Excel try to learn how to copy/paste formulas from cells and what ‘absolute cell reference’ and ‘relative cell reference’ mean.
Place this order or similar order and get an amazing discount. USE Discount code “GET20” for 20% discount