Access Millions of academic & study documents

Sensitivity Analysis

Content type
User Generated
Subject
Business
School
Pasco Hernando State College
Type
Homework
Showing Page:
1/5

Sign up to view the full document!

lock_open Sign Up
Showing Page:
2/5

Sign up to view the full document!

lock_open Sign Up
Showing Page:
3/5

Sign up to view the full document!

lock_open Sign Up
End of Preview - Want to read all 5 pages?
Access Now
Unformatted Attachment Preview
Number of units soldd 50 Sales price per unit Revenue $ $ 11,00 550,00 Purchase price/unit Cost of goods $ $ 10,00 500,00 Before-tax income Tax rate After-tax income $ $ 50,00 35% One- input data table 32,50 # units sold 10 20 30 40 50 60 70 80 90 100 Two -input data table AT income # of units Sold $ 32,50 10 20 30 50 60 70 80 90 100 $ $ $ $ $ $ $ $ $ $ 6,00 (26,00) (52,00) (78,00) (130,00) (156,00) (182,00) (208,00) (234,00) (260,00) $ $ $ $ 30% 210,00 175,00 140,00 105,00 Assignment Two input data table AT income $ 32,50 5 6 7 8 purchase price purchase price 9 10 11 12 13 $ $ $ $ $ 70,00 35,00 (35,00) (70,00) Revenue $ 550,00 $ 110,00 $ 220,00 $ 330,00 $ 440,00 $ 550,00 $ 660,00 $ 770,00 $ 880,00 $ 990,00 $ 1.100,00 $ $ $ $ $ $ $ $ $ $ $ $ $ $ 7,00 (19,50) (39,00) (58,50) (97,50) (117,00) (136,50) (156,00) (175,50) (195,00) 32% 204,00 170,00 136,00 102,00 After text income $ 32,50 $ 6,50 $ 13,00 $ 19,50 $ 26,00 $ 32,50 $ 39,00 $ 45,50 $ 52,00 $ 58,50 $ 65,00 $ $ $ $ $ $ $ $ $ $ 8,00 (13,00) (26,00) (39,00) (65,00) (78,00) (91,00) (104,00) (117,00) (130,00) $ $ $ $ $ $ $ $ $ $ $ $ $ $ Tax rate 34% 198,00 $ 165,00 $ 132,00 $ 99,00 $ Sales price 9,00 $ 10,00 (6,50) $ (13,00) $ (19,50) $ (32,50) $ (39,00) $ (45,50) $ (52,00) $ (58,50) $ (65,00) $ - 36% 192,00 160,00 128,00 96,00 $ $ $ $ 38% 186,00 155,00 124,00 93,00 $ $ $ $ $ $ $ $ $ $ 11,00 6,50 13,00 19,50 32,50 39,00 45,50 52,00 58,50 65,00 $ $ $ $ 40% 180,00 150,00 120,00 90,00 $ ...
Purchase document to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.
Studypool
4.7
Indeed
4.5
Sitejabber
4.4