You may always research using credible online sources of corporate financial information; just be sure that wherever you obtain financial information, you cite your source.
For this discussion, you will look at the financial statements for the company you selected (Apple) and, using the previous quarter’s financial data, interpret the data and propose a budget for the next quarter based on your current and prior analysis of company performance.
Complete the budget template using the
Operating Budget Template
Download Operating Budget Template
:
List the current sales, discounts and allowances, net sales, margins, operating costs, and earnings before and after taxes. Include a minimum of two financial ratios (below) in your analysis.
Prepare the next quarter’s budget based on your interpretation of past data.
Include at least three of the following types of relevant financial ratios in your analysis
Profitability Ratio
Liquidity Ratio
Solvency Ratio
Valuation Ratio
Leverage Ratio
Apple: Operating Budget Q1
Revenue
[Prior Quarter]
Budget
Projection Next Q
Var +/-
Var %
[Prior Quarter]
Budget
Projection Next Q
Var +/-
Var %
[Prior Q]
Proj. Q.
Change
Sales Revenue
Interest Income
Investment Income
Other Income
TOTAL INCOME
Costs and Expenses
Advertising
Health Insurance
Installation/Repair of
Equipment
Inventory Purchases
Salaries
Supplies
Insurance
Rent/Lease Payments
Other Expenses
TOTAL EXPENSES
NET PROFIT/LOSS
Net Earnings Before Taxes
(Gain or Loss)
Income Tax Expense
Net Earnings After Taxes
Ratio Analysis (Choose a minimum of two)
Profitability Ratio
Liquidity Ratio
Solvency Ratio
Valuation Ratio
Leverage Ratio