Chapter_04 - Chapter 4 Problems 1-76 Input boxes in tan...

Info iconThis preview shows pages 1–19. Sign up to view the full content.

View Full Document Right Arrow Icon
Chapter 4 Problems 1-76 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 "Tools|Add-Ins" and select "Analysis ToolPak" and "Solver Add-In."
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Chapter 4 Question 1 Input area: Interest rate 7% Deposit $5,000 # of years 10 Output area: Compound interest $9,835.76 Simple interest $8,500.00 Difference = $1,335.76
Background image of page 2
Chapter 4 Question 2 Input area: Present value $1,000 Years Rate a. 10 5% b. 10 7% c. 20 5% Output area: a. Future value $1,628.89 b. Future value $1,967.15 c. Future value $2,653.30
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Chapter 4 Question 3 Output area: Input area: Present value Years Interest rate Future value $11,529.77 6 5% $15,451 $20,154.91 9 11% 51,557 $61,266.87 18 16% 886,073 $10,067.28 23 19% 550,164
Background image of page 4
Chapter 4 Question 4 Input area: Output area: Present value Years Interest rate Future value $265 2 7.63% $307 360 9 10.66% 896 39,000 15 9.97% 162,181 46,523 30 8.12% 483,500
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Chapter 4 Question 5 Input area: Output area: Present value Years Interest rate Future value $625 9.36 8% $1,284 810 24.81 7% 4,341 18,400 16.19 21% 402,662 21,500 8.20 29% 173,439
Background image of page 6
Chapter 4 Question 6 Input area: Output area: Present value Years Interest rate Future value $1.00 10.24 7% $2.00 1.00 20.49 7% 4.00
Background image of page 7

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Chapter 4 Question 7 Output area: Input area: Present value Years Interest rate Future value $130,258,959.12 20 9.50% $800,000,000
Background image of page 8
Chapter 4 Question 8 Output area: Input area: Present value Years Interest rate Future value $52,827.67 10 11.0% $150,000
Background image of page 9

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Chapter 4 Question 9 Input area: Annual payments $120 Interest rate 15% Output area: Present value $800.00
Background image of page 10
Chapter 4 Question 10 Input area: Present value $1,000 Years Rate a. 5 12% b. 3 10% c. 10 5% d. 8 7% Output area: a. Future value $1,822.12 b. Future value $1,349.86 c. Future value $1,648.72 d. Future value $1,750.67
Background image of page 11

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Chapter 4 Question 11 Input area: Output area: Discount rate 24% Year Cash flow 1 $1,200 2 600 3 855 4 1,480 $2,432.40
Background image of page 12
Chapter 4 Question 12 Input area: Discount rate 5% # of years for X 9 # of years for Y 5 Payment for X $4,000 Payment for Y 6,000 Output area: Value of X = $28,431.29 Value of Y = $25,976.86
Background image of page 13

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Chapter 4 Question 13 Input area: Required rate of return 10% # of years 15 Payment per year $3,600 Output area: Present value $27,381.89 PV (forever) $36,000.00
Background image of page 14
Chapter 4 Question 14 Input area: Interest rate 8% Desired amount $15,000 Cost of policy $195,000 Output area: Present value = $187,500.00 Required interest rate = 7.69%
Background image of page 15

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Chapter 4 Question 15 Input area: Output area: Stated rate (APR) # of times per year Effective rate 11% 4 11.46% 7% 12 7.23% 9% 365 9.42% 17% Infinite 18.53%
Background image of page 16
Chapter 4 Question 16 Input area: Output area: Stated rate (APR) # of times per year Effective rate 7.94% 2 8.10% 7.35% 12 7.60% 15.55% 52 16.80% 23.27% Infinite 26.20%
Background image of page 17

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Chapter 4 Question 17 Input area: Output area: Stated rate (APR) # of times per year Effective rate First National Bank 12.2% 12 12.91% First United Bank 12.4% 2 12.78%
Background image of page 18
Image of page 19
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 12/21/2011 for the course NIKA 101 taught by Professor Temur during the Spring '11 term at Acton School of Business.

Page1 / 76

Chapter_04 - Chapter 4 Problems 1-76 Input boxes in tan...

This preview shows document pages 1 - 19. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online