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