Explore BrainMass

Financial Calculations in Excel

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

Using the partial financial data provided in the Excel (2010) spreadsheet, fill in the missing values for the blue fields using the data provided in the black fields.

Calculations include items for Balance Sheet, Income Statement, Financial Ratios, and Common Size Balance Sheet.

© BrainMass Inc. brainmass.com October 25, 2018, 5:37 am ad1c9bdddf

Solution Preview

The attached spreadsheet contains the calculations for balance sheets, income statements, financial ratios, and common size balance sheets. The answer values are colored blue, next ...

Solution Summary

The solution provides an Excel spreadsheet with dummy data (colored black). Then the various calculations are inserted (blue) to fill out the financial statements. The spreadsheet is divided into two tabs, one for balance sheet and income statement examples, the second for balance sheet, income statement, ratios, and common size balance sheet.

Instructions are also inserted so students can use the features of Excel to Trace Precedent or Trace Dependent cells so that all doubt can be eliminated concerning which data items in the spreadsheet contribute to the answers.

See Also This Related BrainMass Solution

Calculation and Microsoft Excel Charts of Financial Ratios

Consider the attached LuluLemon Case Study and Compute the following ratios:

a. Profitability Ratios
-Gross profit margin
-Operating profit margin
-Net profit margin
-Return on total Assets
-Return on stockholder's equity
b. Liquidity Ratios
-Current ratio
-Working capital
c. Leverage Ratios
-Debt to assets
-Long-term debt to capital
d. Activity Ratios
-Inventory turnover
-Average collection period
e. Internal cash flow
NOTE: Compute sample ratios for all of the years presented in the sample case, in order to assess how strong is the firm financially. Use the ratio calculations on pages C-61-C-62. Use Excel in Microsoft Office to create tables and figures to present your ratio analysis, along with graphs (figures) to track trends in the financial performance of the organization.

View Full Posting Details