Purchase Solution

Desert Coffee Roasters and Pro Forma Financial Statements

Not what you're looking for?

Ask Custom Question

Please see attachments for instructions and details. Thank you.

Based on the data provided in the Cumulative Case Study: Desert Coffee Roasters, Inc.:
a. Select the relevant financial data.
b. Using Excel, prepare 3 years of pro forma financial statements (balance sheet, income statement, and statement of cash flows). Use the formulas and cell links to show your work in the worksheets.
c. Write a 1,050-1,750-word report discussing whether the organization's financial goals have been met and the recommendations you would make to management for improving the organization's financial health.

Purchase this Solution

Solution Summary

This solution explains how to prepare the proforma financial statements for Desert Coffee Roasters. The calculations are in the attached Excel file in the student tab. I have given comments on how the figures are calculated. Financial objectives of the company are discussed and recommendations for meeting its target debt/equity ratio are provided.

Solution Preview

The calculations are in the attached file in the student tab. I have given the comments on how the figures are calculated.

In the end I have ...

Purchase this Solution


Free BrainMass Quizzes
Organizational Behavior (OB)

The organizational behavior (OB) quiz will help you better understand organizational behavior through the lens of managers including workforce diversity.

Team Development Strategies

This quiz will assess your knowledge of team-building processes, learning styles, and leadership methods. Team development is essential to creating and maintaining high performing teams.

Lean your Process

This quiz will help you understand the basic concepts of Lean.

Basic Social Media Concepts

The quiz will test your knowledge on basic social media concepts.

Business Ethics Awareness Strategy

This quiz is designed to assess your current ability for determining the characteristics of ethical behavior. It is essential that leaders, managers, and employees are able to distinguish between positive and negative ethical behavior. The quicker you assess a person's ethical tendency, the awareness empowers you to develop a strategy on how to interact with them.