{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

chap8_cap_challenge_solution

chap8_cap_challenge_solution - Loan Amount Annual Interest...

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

View Full Document Right Arrow Icon
Loan Amount: $30,000.00 Annual Interest Rate: 6.25% 1 Number of Periods: 48 Payment Amount: $707.99 Total Payments: $33,983.74 Total Interest: $3,983.74 6.00% 6.50% 7.00% Payment Amount: $707.99 $704.55 $711.45 $718.39 Total Payments: $33,983.74 $33,818.44 $34,149.53 $34,482.59 Total Interest: $3,983.74 $3,818.44 $4,149.53 $4,482.59 $3,983.74 6.00% 6.50% 7.00% 7.50% $30,000.00 $3,818.44 $4,149.53 $4,482.59 $4,817.62 $31,000.00 $3,945.72 $4,287.85 $4,632.01 $4,978.21 $32,000.00 $4,073.00 $4,426.17 $4,781.43 $5,138.79 $33,000.00 $4,200.29 $4,564.49 $4,930.85 $5,299.38 $34,000.00 $4,327.57 $4,702.80 $5,080.27 $5,459.97 Pmt. Period (months):
Background image of page 1

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

View Full Document Right Arrow Icon
7.50% 8.00% 8.50% $725.37 $732.39 $739.45 $34,817.62 $35,154.61 $35,493.56 $4,817.62 $5,154.61 $5,493.56 8.00% 8.50% 9.00% $5,154.61 $5,493.56 $5,834.46 $5,326.43 $5,676.68 $6,028.94 $5,498.25 $5,859.79 $6,223.43 $5,670.07 $6,042.91 $6,417.91 $5,841.89 $6,226.03 $6,612.39
Background image of page 2
Maintenance Department PMT Function - The Purchase of Snow Equipment Purchase Price $44,337 Manufacturer's Rebate $375 Down Payment $3,000 Amount to Finance $40,962 Interest Rate 8% Term (years) 4 Monthly Payment $1,000.00
Background image of page 3

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

View Full Document Right Arrow Icon
Scenario Summary Current Values: Consensus Optimistic Pessimistic Changing Cells: $E$23 $C$18 10,000 10,000 12,000 8,000 $C$19 $125.00 $125.00 $150.00 $110.00 $E$18 10.0% 10.0% 1.5% 5.0% Result Cells: $E$23 Notes: Current Values column represents values of changing cells at time Scenario Summary Report was created. Changing cells for each scenario are highlighted in gray.
Background image of page 4
Scenarios (All) 0 1 2 3 4 5 6 7 8 9 10 Total Column B
Background image of page 5

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

View Full Document Right Arrow Icon
Golf Shoppe Club Creation 2008 2009 2010 2011 2012 Income Revenues Units Sold 10,000 11,000 12,100 13,310 14,641 Unit Price $125.00 $131.25 $137.81 $144.70 $151.94 Gross Revenue $1,250,000 $1,443,750 $1,667,531 $1,925,999 $2,224,528 Expenses
Background image of page 6
Image of page 7
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}