Purchase Solution

Capstan Auto case

Not what you're looking for?

Ask Custom Question

Please see attached files.

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

Purchase this Solution

Solution Summary

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

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. ...

Purchase this Solution


Free BrainMass Quizzes
Six Sigma for Process Improvement

A high level understanding of Six Sigma and what it is all about. This just gives you a glimpse of Six Sigma which entails more in-depth knowledge of processes and techniques.

Academic Reading and Writing: Critical Thinking

Importance of Critical Thinking

Marketing Management Philosophies Quiz

A test on how well a student understands the basic assumptions of marketers on buyers that will form a basis of their marketing strategies.

Paradigms and Frameworks of Management Research

This quiz evaluates your understanding of the paradigm-based and epistimological frameworks of research. It is intended for advanced students.

MS Word 2010-Tricky Features

These questions are based on features of the previous word versions that were easy to figure out, but now seem more hidden to me.