Explore BrainMass
Share

Explore BrainMass

    Desert Coffee Roasters and Pro Forma Financial Statements

    This content was COPIED 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 April 3, 2020, 3:47 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

    ADVERTISEMENT