Purchase Solution

Equations for equity and net sales.

Not what you're looking for?

Ask Custom Question

The attached spreadsheet is for estimating R&E Supplies' external financing required for 2006. With modifications to the equations for equity and net sales, the forecast can be extended through 2007.

Write the modified Excel equations for equity and net sales.

Attachments
Purchase this Solution
Solution Summary

The solution writes a modified Excel equation for equity and net sales.

Solution Preview

I had to remake pretty much the entire forecast Income statement for 2007 since computing equity part would require some ...

Purchase this Solution
Free BrainMass Quizzes
MS Word 2010-Tricky Features

These questions are based on features of the previous word versions that were easy to figure out, but now seem more hidden to me.

Situational Leadership

This quiz will help you better understand Situational Leadership and its theories.

Basics of corporate finance

These questions will test you on your knowledge of finance.

Production and cost theory

Understanding production and cost phenomena will permit firms to make wise decisions concerning output volume.

Motivation

This tests some key elements of major motivation theories.

View More Free Quizzes
Related BrainMass Solutions

  • Explanation and Calculation of Du Pont Identity

    DuPont identity: ROE = Net Income/Sales * Sales/Assets * Assets/Shareholders' Equity This identity starts from ROE (Net Income/Shareholders' Equity) but takes into its fold very important ratios viz- Net Profit Margin, Asset Turnover Ratio and Financial

  • Rate of return on Equity (ROE)

    Rate of return on Equity (ROE) = Net Income / Shareholders' Equity This ratio can be re-written as a product of the three principal components: ROE = (Net Income/Sales) x (Sales/Assets) x (Assets/Shareholders' Equity) The three components are

  • Starbucks Analysis - Return on Equity & Days Receivable

    Therefore, we need to go to the Consolidated Statements and locate amounts for Net Income (also referred to as Net Earnings) and Shareholder's Equity to make the calculation of ROE.

  • Financial Ratios and Profitability Explanations



    Return on common equity (ROCE): net income/avg. net common shareholders' equity (avg. of common stock at par + retained earnings over the year, same problem) 4,200/48,810 * 100 = 8.6%

    Profit margin: net income/sales (sales=revenues

  • Create cash flow from financial statements

    Total Liabilities and Stockholders' Equity 870,000.00 1,000,000.00 Income Statement for the year ended 12/31/2011 Amount in Dollars Sales 2,000,000.00 Cost of Goods Sold 1,500,000.00 Gross Profit 500,000.00 Selling and Administrative

  • Financial Statements: Basic Formats, Accounting Equations

    A typical one would show: Sales -Cost of goods sold =Gross profit -Operating expense =Operating Income -Interest Expense =Income before taxes -Tax expense =Net Income Balance Sheet: Assets, liabilities and equity are listed.

  • Use of accounting equation, Gomez increase or decrease, LIFO

    Use the following information to calculate three profitability ratios for CMP Inc. for the year: Net income $12,000 Sales $88,000 Total assets $140,000 Total common stockholders' equity $96,000 a.

  • Present Value, Future Value, ROA, ROE

    A firm has net working capital of $400, net fixed assets of $2,400, sales of $6,000, and current liabilities of $800. How many dollars worth of sales are generated from every $1 in total assets?

  • Financial Management Profit Margins

    __ 6.7X Sales/fixed assets ______ 12.1X Sales/total assets ______ 3.0X Net income/sales ______ 1.2% Net income/total assets ______ 3.6% Net income/ common equity ______ 9.0% Total debt/ total assets _

View More Related Solutions