Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I have attached screenshots of the assignment below. I am supposed to use formulas and then drag them across. I am not sure what the

I have attached screenshots of the assignment below. I am supposed to use formulas and then drag them across. I am not sure what the formulas need to be. If you can type them next to the line item it will help me learn what they are. image text in transcribedimage text in transcribedimage text in transcribed

W06 Financial Statement Project 5 Projected Financial Statements For Laie Ukuleles $ $ Price per unit Var Cost per unit Annual Growth Rate General expense 150 80 50% 1,500 Assumptions A/R % of sales Inv % of COGS A/P % of COGS Equipment Life in months 10% 25% 15% 60 $ Sales in Units 20 21 22 Dec Jan Feb Mar P&L Statement Sales Cost of Goods Sold Gross profit General Expenses Depreciation Total Expenses Net Income March Net Income = (31) = Statement of Cash Flows Operating Activities Net Income Changes in Cur. Assets and Liabilites Change In Accounts Receivable Change In Inventory on Hand Change In Accounts Payable Non-cash expenses Depreciation Cash Flow from Operating Activities Investing Activities Change In Equipment Cash Flow from Investing Activities Investing Activities Change In Equipment Cash Flow from Investing Activities Financing Activities Change In Notes Payable Change In Paid-in-Capital Change In Less: Owner's Withdrawal Cash Flow from Financing Activities Net increase/(decrease) in cash Cash--beginning of month Cash--end of month March Cash = 1,378 $ 5,000 Balance Sheet Assets Cash Accounts Receivable Inventory Equipment Less Accumulated Depreciation Total Assets $ 5,000 GA $ Liabilities Accounts Payable Notes Payable Total Liabilities 5,000 Owner's Equity Paid-in-Capital $ Less: Owner's Withdrawal Retained Earnings Total Owner's Equity $ Total Liabilities and Owner's Equity 5,000 January activity tot buitbccnon ob sebiob contributed by the nasambar 5,000 Owner's Equity Paid-in-Capital $ Less: Owner's Withdrawal Retained Earnings Total Owner's Equity Total Liabilities and Owner's Equity $ 5,000 January activity Start business with $5,000 cash which was contributed by the owner in December Purchase $3,000 equipment with cash in January. Calculate depreciation over 60 months. After completing budgeted financial statements, answer the following: If the price per unit increases to $175, what is the profit or loss in February and the cash balance at the end of February? After answering the question, change the "Price Per Unit" back to $150 and save your spreadsheet

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Planning And Budgeting For The Agile Enterprise A Driver-based Budgeting Toolkit

Authors: Barrett, Richard

1st Edition

0750683279, 9780750683272

More Books

Students also viewed these Accounting questions

Question

12.6 Analyze the emerging emphasis on employee recognition.

Answered: 1 week ago