Answered step by step
Verified Expert Solution
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.
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 spreadsheetStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started