Explore BrainMass
Share

Desert Coffee Roasters and Pro Forma Financial Statements

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

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.

© BrainMass Inc. brainmass.com December 19, 2018, 10:19 pm ad1c9bdddf
https://brainmass.com/business/capital-budgeting/desert-coffee-roasters-and-pro-forma-financial-statements-87242

Attachments

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

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.

$2.19