| 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? | |||||||||||||||
We Write Essays for Students
Tell us about your assignment and we will find the best writer for your paper
Get Help Now!“Order a custom Paper on Similar Assignment! No Plagiarism! Get 20% Discount by using this Coupon Code: SUPER20 “
Welcome to originalessaywriters.com, our friendly and experienced essay writers are available 24/7 to complete all your assignments. We offer high-quality academic essays written from scratch to guarantee top grades to all students. All our papers are 100% plagiarism-free and come with a plagiarism report, upon request
Tell Us “Write My Essay for Me” and Relax! You will get an original essay well before your submission deadline.
