Sensitivity Analysis Data

Sensitivity Analysis Data - $14,000.00 $16,000.00...

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

View Full Document Right Arrow Icon
Region Salesperson Year Sales(units) Sales ($) East Ron 1999 120 14400 East Ron 2000 150 18000 East Erica 1999 134 16080 East Erica 2000 144 17280 West Tina 2000 100 12000 West Tina 1999 70 8400 West Bob 1999 21 2520 West Bob 2000 45 5400 East Paula 1999 200 24000 East Kelly 1999 75 9000 East Kelly 2000 75 9000 East Paula 2000 250 30000 price= 120 Year Region Data 1999 2000 Grand Total East Sum of Sales(units) 529 619 1148 Sum of Sales ($) 63480 74280 137760 West Sum of Sales(units) 91 145 236 Sum of Sales ($) 10920 17400 28320 Total Sum of Sales(units) 620 764 1384 Total Sum of Sales ($) 74400 91680 166080 East East profit margin= 15.00% 1999 profit $11,706.00 West profit margin= 20.00% 2000 profit $15,538.80 Margin increase= 1.00% NPV= $25,622.26 Rate of return= 4.00% 1999 profit 2000 profit $0.00 $2,000.00 $4,000.00 $6,000.00 $8,000.00 $10,000.00 $12,000.00
Background image of page 1

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

View Full DocumentRight Arrow Icon
Background image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: $14,000.00 $16,000.00 $18,000.00 $11,706.00 $15,538.80 1999 vs. 2000 Profits Profit ($) A B C D E F 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 Mortgage Loan Worksheet Input Cells Purchase Price $201,900 Down Payment 20.00% Loan Term 360 In Years 30 Interest Rate 6.50% Result Cells Formulas Loan Amount $161,520 Purchase_Price*(1 - Down_Payment) Monthly Payment $1,020.92 PMT(Interest_Rate/12, Loan_Term, -Loan_Amount) Total Payments $367,530 Monthly_Payment*Loan_Term Total Interest $165,630 Total_Payments-Purchase_Price...
View Full Document

This document was uploaded on 10/28/2008.

Page1 / 2

Sensitivity Analysis Data - $14,000.00 $16,000.00...

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

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