Share
Explore BrainMass

Capstan Auto case

Please see attached files.

Complete the financial information for Capstan Auto using the attached excel spreadsheet.

Attachments

Solution Preview

Please see the attached file. The cells have formula showing the calculation and cell comments giving the explanations.

2009:Q3 2009:Q4 2010:Q1 2010:Q2 2010:Q3 2010:Q4 2011:Q1 2011:Q2 2011:Q3 2011:Q4 2012:Q1
1. Cars sold 250 200 200 225 250 275 300 325 350 375
2. Unit price 20 20 20 20 20 20 20 20 20 20
3. Unit cost 18 18 18 18 18 18 18 18 18 18
4. Revenues 5,000 4,000 4,000 4,500 5,000 5,500 6,000 6,500 7,000 7,500
5. ...

Solution Summary

The solution explains how to complete the excel spreadsheet for Capstan Auto case relating to working capital.

$2.19