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 U$.$S$.$GAAP.

$1.$ Type in your name above for Student Name.

$2.$ You must compute net income on the income statement below and create a worksheet for cash flow utilizing the $3-$step process as outlined in Chapter $3$ Lecture $($see section below labeled OUTPUT$)$

$3.$ 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$!$

$4.$ Be creative! Examples: Change the font size$/$style$,$ use additional color and or shading & borders; make your spreadsheet look aesthetically pleasing.

$5.$ You must also rename and give a descriptive title to 'Sheet $1\text{'}$ 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 $30$

Use of Cell References $20$

Correct Formatting $20$

Creativity: Use of Shading$/$Color$/$Borders $15$

Student Name is typed in $5$

Label Sheet on Bottom Tab $5$

Overall Neatness & Layout $5$

Total points $100$

Additional Input Data for $2022$:

Effective Tax rate $20\%$ OUTPUT

Cash dividends paid to common shareholders $$500$

Depreciation Expense $$3,500$

Balance Sheet $-----$ STEP $1-----------------------$STEP $2------------------------------------------$STEP $3------------------------------$

Assets: $20222021$ Change Source Use $=$ Operating Investing Financing

Cash $$3,400$ $$5,500$

Marketable Securities $$2,200$ $$2,960$

Accounts Receivable $$12,600$ $$12,200$

Inventory $$25,500$ $$26,000$

Net Property, Plant & Equipment $$110,400$ $$102,140$

Total Assets $$154,100$ $$148,800$

Liabilities & Stockholders' Equity:

Accounts Payable $$24,700$ $$24,000$

Accrued Expenses $$12,000$ $$12,900$

Long$-$term Bonds Payable $$34,000$ $$31,900$

Total Debt $$70,700$ $$68,800$

Preferred Stock $$5,300$ $$5,000$

Common Stock $$55,600$ $$56,000$

Retained Earnings $$22,500$ $$19,000$

Total Liabilities & Stockholders' Equity $$154,100$ $$148,800$

CFO CFI CFF

Income Statement $2022$ change in cash

Sales $$645,000$

Cost of Goods Sold $$450,000$

Gross Profit

Operating Expenses $($including depreciation$)$ $$180,000$

EBIT

Gain on sale of land $$2,000$

Interest Expense $$12,000$

EBT

Tax

Net income