Question and Problem Sets 2
Lynnette
Chapter_05_Problems_3_and_4templates.xlsxChapter 5
| Chapter 5 | |||
| Problems 1, 2, 3, 4, 5 | |||
| Input boxes in tan | |||
| Output boxes in yellow | |||
| Given data in blue | |||
| Calculations in red | |||
| Answers in green | |||
| NOTE: Some functions used in these spreadsheets may require that | |||
| the "Analysis ToolPak" or "Solver Add-In" be installed in Excel. | |||
| To install these, click on the Office button | |||
| then "Excel Options," "Add-Ins" and select | |||
| "Go." Check "Analyis ToolPak" and | |||
| "Solver Add-In," then click "OK." | |||
#1
| Chapter 5 | |||
| Question 1 | |||
| Input area: | |||
| Interest rate | |||
| Deposit | |||
| # of years | |||
| Output area: | |||
| Simple interest | |||
| per year | $ - 0 | ||
| Total simple interest | $ - 0 | ||
| FV with simple interest | $ - 0 | ||
| Compound interest | $0.00 | ||
| Difference | $ - 0 | ||
#2
| Chapter 5 | |||||
| Question 2 | |||||
| Input area: | Output area: | ||||
| Present value | Years | Interest rate | Future value | ||
| $ - 0 | |||||
| $ - 0 | |||||
| $ - 0 | |||||
| $ - 0 | |||||
#3
| Chapter 5 | |||||
| Question 3 | |||||
| Output area: | Input area: | ||||
| Present value | Years | Interest rate | Future value | ||
| $ - 0 | |||||
| $ - 0 | |||||
| $ - 0 | |||||
| $ - 0 | |||||
#4
| Chapter 5 | |||||
| Question 4 | |||||
| Input area: | Output area: | ||||
| Present value | Years | Interest rate | Future value | ||
| ERROR:#NUM! | |||||
| ERROR:#NUM! | |||||
| ERROR:#NUM! | |||||
| ERROR:#NUM! | |||||
#5
| Chapter 5 | |||||
| Question 5 | |||||
| Input area: | Output area: | ||||
| Present value | Years | Interest rate | Future value | ||
| ERROR:#DIV/0! | |||||
| ERROR:#DIV/0! | |||||
| ERROR:#DIV/0! | |||||
| ERROR:#DIV/0! | |||||
