| GENERAL INSTRUCTIONS FOR COMPUTERIZED PROBLEM SOLUTIONS | ||||||
| We have already entered the base case data for each model in this | ||||||
| file, and the models have performed the analysis for preceding parts | ||||||
| of the problem. You will need to enter the data for each of the | ||||||
| remaining parts of the problem–we indicate in each problem the parts | ||||||
| that should be done using the spreadsheet. However, there are several | ||||||
| points worth noting before you go into a model: | ||||||
| 1. The input data are entered in specified cells in the INPUT DATA | ||||||
| section. When you change an input item, the model automatically | ||||||
| recalculates the values of appropriate output data items, unless | ||||||
| you are told otherwise. If the values do not change automatically, | ||||||
| press the F9 key to recompute the values. | ||||||
| 2. The key output data are displayed to the right of the INPUT DATA | ||||||
| section or immediately below it. This placement permits you to | ||||||
| change an input and instantly see how that change affects the output | ||||||
| of the model. This is extremely useful in sensitivity analysis. | ||||||
| 3. Input data items that you can change are distinguished from the | ||||||
| ones you should not change. The items that you can change are | ||||||
| highlighted in color (blue) whereas the other items are printed in black. | ||||||
| 4. All percentages must be entered as decimals. Dollars and other | ||||||
| numbers must be entered without dollar signs or commas. | ||||||
| 5. Instructions and comments concerning specific models accompany | ||||||
| each model. Graphs associated with the model are included in | ||||||
| another worksheet that can be accessed by clicking on the | ||||||
| worksheet labeled GRAPH at the bottom of the spreadsheet. | ||||||
| Chapter 4 Spreadsheet Problem | |||||||||||||||
| Time Value of Money | |||||||||||||||
| Use the computerized model in the File C04 to solve one of these problems. Pick one but be sure to list the one that you pick. | |||||||||||||||
| a. Set up an amortization schedule for a $30,000 loan to be repaid in equal installments at the end of each of the next 20 years at an interest rate of 10 percent. What is the annual payment? | |||||||||||||||
| b. Set up an amortization schedule for a $60,000 loan to be repaid in 20 equal annual installments at an interest rate of 10 percent. What is the annual payment? | |||||||||||||||
| c. Set up an amortization schedule for a $60,000 loan to be repaid in 20 equal annual installments at an interest rate of 20 percent. What is the annual payment? | |||||||||||||||
What Students Are Saying About Us
.......... Customer ID: 12*** | Rating: ⭐⭐⭐⭐⭐"Honestly, I was afraid to send my paper to you, but you proved you are a trustworthy service. My essay was done in less than a day, and I received a brilliant piece. I didn’t even believe it was my essay at first 🙂 Great job, thank you!"
.......... Customer ID: 11***| Rating: ⭐⭐⭐⭐⭐
"This company is the best there is. They saved me so many times, I cannot even keep count. Now I recommend it to all my friends, and none of them have complained about it. The writers here are excellent."
"Order a custom Paper on Similar Assignment at essayfount.com! No Plagiarism! Enjoy 20% Discount!"
