Categories: Assignment Help

I need a 1 page paper with 4 financial statements in Excel f

I need a 1 page paper with 4 financial statements in Excel f.
I need a 1 page paper with 4 financial statements in Excel format on the following information:You are an accountant for The Flower Shoppe. Your supervisor has asked you to help her prepare the year-end financial statements. Before you do, she wants to ensure that you understand some main points.Explain the following: The elements of the balance sheet, their purposes, and how to measure them The elements and purpose of the statement of changes in stockholder s equity Based on the adjusted trial balance and additional information, prepare the following in an Excel file to give to the controller for review: Balance sheet Income statement Statement of retained earnings Statement of cash flows The following is additional information about the Flower Shoppe that is needed for financial-statement preparation:Net income for the year ended December 31, 2008 was $10,845. Changes from the prior year s balances included the following: a decrease in accounts receivable of $300. a decrease in inventory of $450. an increase in accounts payable of $250. an decrease in accrued expenses of $100. Land was purchased in April for $3,500. Cash as of January 1, 2008 was $10,105. The Flower ShoppeAdjusted Trial BalanceDecember 31, 2008DebitCreditCash$22,750Accounts Receivable3,200Inventory8,000Land27,000Building56,000Accumulated Depreciation16,800Accounts Payable4,600Accrued Expenses2,500Common Stock20,000Additional Paid-in Capital10,000Dividends1,200Retained Earnings53,405Sales112,020Returns1,300Purchases47,000Salaries38,000Supplies870Utilities5,225Telephone2,850Bank Charges330Depreciation Expense5,600$219,325$219,325
I need a 1 page paper with 4 financial statements in Excel f

Don't use plagiarized sources. Get Your Custom Essay on
I need a 1 page paper with 4 financial statements in Excel f
For $10/Page 0nly
Order Essay
admin

Share
Published by
admin

Recent Posts

Economic Debate #3- Progressive Income Tax – The Homework Helper

Economic Debate- Progressive Income Tax For this Economic Debate, we are going to discuss the…

2 years ago

MKT 6120 – Marketing Management – Davis Learning Engagement #7

TOPIC: Going Global Discussion Thread 1 (initial post due Wednesday for full credit) Please note:…

3 years ago

jvjvjhvjhvhjvj

Assignment Topic This week will culminate in the creation of a narrated PowerPoint to create…

3 years ago

Students are supposed to select a technological organization of their choice.

The Assignment must be submitted on Blackboard (WORD format only) via allocated folder. Assignments submitted…

3 years ago

Increases the risk of wildfires

you need to post your 2-page information flier to share with your Final Project Group.…

3 years ago

Statistics for Technology management

discussion: Discuss the methods used at your company to measure and ensure quality products and…

3 years ago