Student Name Greenfin Corporation Instructions: Below are the two most recent balance sheets and most recent income
Fantastic news! We've Found the answer you've been seeking!
Question:
Student Name
Greenfin Corporation
Instructions:
Below are the two most recent balance sheets and most recent income statement for the Greenfin, a nonfinancial company following USGAAP.
Type in your name above for Student Name.
You must compute net income on the income statement below and create a worksheet for cash flow utilizing the step process as outlined in Chapter Lecture see section below labeled OUTPUT
You MUST use cell references for your answers and format all currency as US $ with zero decimal places. There should be NO numbers simply typed in
Be creative! Examples: Change the font sizestyle use additional color and or shading & borders; make your spreadsheet look aesthetically pleasing.
You must also rename and give a descriptive title to 'Sheet located at the bottom of the spreadsheet that looks like this.
Make sure the title is descriptive and reflects the nature of this assignment so that someone outside of this class would be able
to understand it
Grading Rubrics Points
Mathematical Acccuracy
Use of Cell References
Correct Formatting
Creativity: Use of ShadingColorBorders
Student Name is typed in
Label Sheet on Bottom Tab
Overall Neatness & Layout
Total points
Additional Input Data for :
Effective Tax rate OUTPUT
Cash dividends paid to common shareholders $
Depreciation Expense $
Balance Sheet STEP STEP STEP
Assets: Change Source Use Operating Investing Financing
Cash $ $
Marketable Securities $ $
Accounts Receivable $ $
Inventory $ $
Net Property, Plant & Equipment $ $
Total Assets $ $
Liabilities & Stockholders' Equity:
Accounts Payable $ $
Accrued Expenses $ $
Longterm Bonds Payable $ $
Total Debt $ $
Preferred Stock $ $
Common Stock $ $
Retained Earnings $ $
Total Liabilities & Stockholders' Equity $ $
CFO CFI CFF
Income Statement change in cash
Sales $
Cost of Goods Sold $
Gross Profit
Operating Expenses including depreciation $
EBIT
Gain on sale of land $
Interest Expense $
EBT
Tax
Net income
Related Book For
Financial Management Principles and Applications
ISBN: 978-0134417219
13th edition
Authors: Sheridan Titman, Arthur J. Keown, John H. Martin
Posted Date: