Exercice solution (me).xlsx - Price Unit Sold Market Share Market Size Variable Cost per unit Revenue Variable Cost Fixed Cost Depreciation SLM Pretax

Exercice solution (me).xlsx - Price Unit Sold Market Share...

This preview shows page 1 - 9 out of 9 pages.

1-5 Revenue 6000 Variable Cost 3000 Fixed Cost 1791 Depreciation SLM 300 Pretax Profit 909 Tax (28%) 254.52 Net Profit 654.48 Cash Flow 954.48 Initial Investment 1500 Cost of Capital 15% NPV Net Cumulative Profit Price 2 Unit Sold 3000 Market Share 0.3 Market Size 10,000 Variable Cost per unit 1 UNITS SOLD = MARKET SHARE * MARKET SIZE TO DELATE FIELDS -> FN + ENTER+ DELATE units sold 1500 Revenue 3000 Variable cost 1500 Fixed Cost 1791 Depreciation SLM 300 Pretax Profit -591 Tax 28% -165.48 Net profit -425.52 cash flow -125.52 initial investment 1500 PESIMISTC We change 1 factor : units sold
Image of page 1
Cost of Capital 15% NPV -£1,920.76 Al vender menos, el NPV disminu -1500 -125.52 -125.52 -125.52 We can change more than 1 factor In our case we change: Market size 7000 Market share 20% BOTH CHANGE AND THAT MAKES THE UNITS 1400 UNITS 1400 we can make a lot of scenarios as for example changing at the same time: selling price and Number of units sold ?
Image of page 2
we are searching for the number of units that we have to sell to cover all the costs and ma Revenue Variable cost Fixed Cost Depreciation SLM Pretax Profit Tax 28% Net profit cash flow initial investment Cost of Capital NPV
Image of page 3
6000 3000 1791 (no cambia) 300 (no cambia) 909 254.52 654.48 954.48 se suma la depreciacion 1500 15% Price
Image of page 4
Image of page 5
Image of page 6
Image of page 7
Image of page 8
Image of page 9

You've reached the end of your free preview.

Want to read all 9 pages?

Unformatted text preview: 2 Unit sold 3000 market share 0.3 market size 10,000 variable cost per unit 1 E SENSIVITY (BECAUSE IT CHANGED EITER THE MARKET SHARE OR THE MARKET SIZE, BUT JUST 1 OF TH CHANGED uye-125.52-125.52 SCENARIO ANALYSIS d v. cost per unit BREAK-EVEN NPV= 0 SOLAR ELECTRONICS Revenue 6000 Variable cost 3000 Fixed Cost 1791 Depreciation SLM 300 Pretax Profit 909 Tax 28% 254.52 Net profit 654.48 cash flow 954.48 initial investment 1500 Cost of Capital 15% NPV £1,699.56 Net cumulative profit-1500 954.48 954.48 954.48 954.48 954.48 HEM) 6000 Revenue 12000 Variable cost 6000 Fixed Cost 1791 Depreciation SLM 300 Pretax Profit 3909 Tax 28% 1094.52 Net profit 2814.48 cash flow 3114.48 initial investment 1500 OPTIMISTIC We change 1 factor: units sold are 6000 Cost of Capital 15% NPV £8,940.22 Al vender mas, el NPV aumenta-1500 3114.48 3114.48 3114.48 3114.48 3114.48 Revenue 2800 Variable cost 1400 Fixed Cost 1791 Depreciation SLM 300 Pretax Profit-691 Tax 28%-193.48 Net profit-497.52 cash flow-197.52 initial investment 1500 Cost of Capital 15% NPV-£2,162.12-1500-197.52-197.52-197.52-197.52-197.52...
View Full Document

  • One '14

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern

Ask Expert Tutors You can ask You can ask ( soon) You can ask (will expire )
Answers in as fast as 15 minutes