Assignment 2: Course Project—Cost-Volume-Profit Analysis with Capital Budgeting
cabo1789
CVPTemplate.xlsCVP
| Sales price per unit | $75.00 | * | |||
| Variable Cost per unit | $67.00 | * | |||
| Fixed Cost | $100,000.00 | * | |||
| Targeted Net Income | $0.00 | * | (assume 0 if you want to calculate breakeven) | ||
| Calculated Volume | 12,500 | calculated | |||
| * inputted by user | Break Even Point=Fixed Cost/(Sales Price Per Unit-Variable Cost) | ||||
| $12,500.00 | |||||
| Sales price per unit | $75.00 | IRR=D18:D23 | |||
| Variable Cost per unit | $67.00 | $67.00 | |||
| Fixed Cost | $100,000.00 | ||||
| Targeted Net Income | 0 | ||||
| Calculated Volume | 12,500 | ||||
| NPV=IRR | |||||
| $67.00 |
