chap8_ho2_gss_solution

chap8_ho2_gss_solution - $1,667,531 $1,925,999 $2,224,528...

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

View Full Document Right Arrow Icon
The Golf Shoppe PMT Function - The Purchase of Golf Cars Purchase Price $60,000 Manufacturer's Rebate $375 Down Payment $3,000 Amount to Finance $56,625 Interest Rate 6% Term (years) 5 Monthly Payment $1,094.72
Background image of page 1

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

View Full DocumentRight Arrow Icon
Scenario Summary Current Values: Consenus Optimistic Changing Cells: First_year_sales 10,000 10,000 12,000 Selling_price $125.00 $125.00 $150.00 Increase_in_sales 10.0% 10.0% 15.0% Result Cells: 2012 Earnings Before Taxes $432,681 $432,681 $1,300,696
Background image of page 2
Pessimistic 8,000 $110.00 5.0% $77,027
Background image of page 3

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

View Full DocumentRight Arrow Icon
Scenarios (All)
Background image of page 4
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
Background image of page 5
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: $1,667,531 $1,925,999 $2,224,528 Expenses Fixed Costs Production facility $50,000 $54,000 $58,320 $62,986 $68,024 Administration $25,000 $26,250 $27,563 $28,941 $30,388 Variable cost Unit mfg cost $79.00 $86.90 $95.59 $105.15 $115.66 Variable mfg cost $790,000 $955,900 $1,156,639 $1,399,533 $1,693,435 Earnings before ta $385,000 $407,600 $425,010 $434,539 $432,681 Assumptions Initial Values Increase First year sales 10,000 10.0% Selling price $125.00 5.0% Unit mfg cost $79.00 10.0% Production facility $50,000 8.0% Administration $25,000 5.0% First year of forecast 2008 Consenus...
View Full Document

This note was uploaded on 04/28/2010 for the course IS 6 taught by Professor 6 during the Spring '10 term at Alfred State College.

Page1 / 5

chap8_ho2_gss_solution - $1,667,531 $1,925,999 $2,224,528...

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

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