this is an excel style practice. it is all one problem and each line is numbered. the answers go where it says FORMULA A6 Data Section:78 Actual and Budgeted Unit Sales:9 AprilMay1011 June12July13 August14 September1516 Balance Sheet, May 31, 19X517 Cash18 Accounts receivable19 Merchandise inventory20Fixed assets (net)21222324252627282930 Average selling price31 Average purchase cost per unit32 Desired ending inventory33 (% of next month's unit sales)BTotal assets4546Accounts payable (merchandise)Owner's equityTotal liabilities & equity34 Collections from customers:35 Collected in month of saleCollected in month after sale37 Collected two months after sale3638 Projected cash payments:39 Variable expenses4041 Depreciation per month424344 Answer Section:Fixed expenses (per month)Sales Budgetс1,5001,0001,6001,4001,5001,200$8,000107,80052,800130,000$298,600========$74,800223,800$298,600========$98$5560%20%60%20%D30% of sales$10,000$1,000E47484950515253545556 Desired ending inventory57 Current month's unit sales5859 Total units needed60 Beginning inventory6162 Purchases (units)UnitsDollars66676364 Purchases (dollars)65828384858687Unit Purchases Budget68697071 Cash balance, beginning72 Cash receipts:73 Collections from customers:74757677787980Total cash available81 Cash disbursements:Cash BudgetFrom April salesFrom May salesFrom June salesFrom July salesFrom August salesMerchandiseVariable expensesFixed expensesInterest paidTotal disbursements8889 Cash balance before financing90 Less: Desired ending balance91‒‒‒‒‒92 Excess (deficit) of cash over needs9394 Financing95 BorrowingJuneFORMULA1FORMULA2JuneFORMULA3FORMULA4FORMULA5FORMULAFORMULA7========FORMULA========June$8,000July00$00July August0000$0August00$127,560 $183,880$74,800 FORMULA0 41,16010,00000000===== ========0$00JulyAugust$42,760 $142,72029,40058,80019,60031,360 94,080 31,36027,440 82,32029,400$285,800$0$84,800$41,160 $54,100$42,760 $142,720 $231,7008,000 8,0008,000$34,760 $134,720 $223,700$044,10010,0000$0 96 Repayment9798 Total effects of financing99100 Cash balance, ending101102103104105106 Sales107 Cost of goods soldForecasted Income StatementFor Quarter Ended August 31, 19X5108109 Gross profit110111 Expenses:112 Variable expenses113114115Fixed expensesDepreciation expenseInterest expenseTotal expenses116117118119 Net income120121122123124125126 CashAssets:Forecasted Balance SheetAugust 31, 19X5127 Accounts receivable128 Merchandise inventory129 Fixed assets (net)130131 Total assets132133 Liabilities & equity:134 Accounts payable135 Loans payable136 Owner's equity137138 Total liabilities & equity139140$0$0$42,760 $142,720$0$231,700FORMULA16FORMULA17FORMULA18FORMULA19FORMULA20FORMULA21FORMULA22$0$0FORMULA23FORMULA24FORMULA25FORMULA26$0FORMULA270FORMULA28$0

Cash budget refers to an estimation of cash inflows and outflows in a business over a specified…

Answered: this is an excel style practice. it is…

Business

Accounting

this is an excel style practice. it is all one problem and each line is numbered. the answers go where it says FORMULA

Fundamentals of Financial Management (MindTap Course List)

15th Edition

ISBN:9781337395250

Author:Eugene F. Brigham, Joel F. Houston

Publisher:Eugene F. Brigham, Joel F. Houston

Chapter4: Analysis Of Financial Statements

Section: Chapter Questions

Problem 24P: Income Statement for Year Ended December 31, 2018 (Millions of Dollars) Net sales 795.0 Cost of...

See similar textbooks

Similar questions

Sunland Limited reported the following selected information for the year ended March 31, 2024: Advertising expense $5,000 Income tax payable $5,200 Cash dividends-common 4,000 Interest expense 5, 100 Depreciation expense 3, 000 Loss on discontinued operations 18,000 Fees earned 66,000 Rent revenue 30, 000 Gain on disposal of equipment 1, 100 Retained earnings, April 1, 2023 15,000 Holding loss on equity investments 3,000 Telephone expense 8,000 The company's income tax rate is 30%. The company reports gains and losses on its equity investments as other comprehensive income. Prepare a multi-step income statement and a separate statement of comprehensive income for Sunland Limited.$ Profit/ (Loss) for the Year $
need formula for cost of goods sold CURRENT ASSETS Cash and cash equivalents $ 607,987 $ 480,626 Accounts receivable, net 104,500 80,545 Inventory 26,445 26,096 Prepaid expenses and other current assets 54,906 57,076 Income tax receivable 282,783 27,705 Investments 343,616 400,156 Total current assets 1,420,237 1,072,204 Leasehold improvements, property and equipment, net 1,584,311 1,458,690 Long term investments 102,328 0 Restricted cash 27,849 27,855 Operating lease assets 2,767,185 2,505,466 Other assets 59,047 18,450 Goodwill 21,939 21,939 Total assets 5,982,896 5,104,604 Current liabilities: Accounts payable 121,990 115,816 Accrued payroll and benefits 203,054 126,600 Accrued liabilities 164,649 155,843 Unearned revenue 127,750 95,195 Current operating lease liabilities 204,756 173,139 Total current liabilities 822,199 666,593 Commitments and contingencies (Note 12) Long-term operating lease liabilities 2,952,296…
Income Statement for Year Ended December 31, 2018 (Millions of Dollars) Net sales 795.0 Cost of goods sold 660.0 Gross profit 135.0 Selling expenses 73.5 EBITDA 61.5 Depreciation expenses 12.0 Earnings before interest and taxes (EBIT) 49.5 Interest expenses 4.5 Earnings before taxes (EBT) 45.0 Taxes (40%) 18.0 Net income 27.0 a. Calculate the ratios you think would be useful in this analysis. b. Construct a DuPont equation, and compare the companys ratios to the industry average ratios. c. Do the balance-sheet accounts or the income statement figures seem to be primarily responsible for the low profits? d. Which specific accounts seem to be most out of line relative to other firms in the industry? e. If the firm had a pronounced seasonal sales pattern or if it grew rapidly during the year, how might that affect the validity of your ratio analysis? How might you correct for such potential problems?
Required information For Year Ended December 31 Sales Cost of goods sold Other operating expenses Current Year $ 411, 225 209,550 12, 100 9,525 $ 673,500 642, 400 $31,100 $ 1.90 :. -. - == ....... 9 US Sa M
Precision Tools 2021 Income Statement Net sales Less: Cost of goods sold Less: Depreciation Earnings before interest and taxes Less: Interest paid $36,408 28,225 1,760 6,423 510 5,913 Taxable Income Less: Taxes 2.070 $3.843 Net Income Precision Tools 2020 and 2021 Balance Sheets 2020 2021 2020 2021 $ Cash 2,060 1,003 Accounts 7,250 8,384 payable Accounts 3,411 4,218 receivable 21.908 27,129 Inventory 18,776 24,247 17,500 3.825 Common stock Retained earnings Total liability & 15,000 Net fixed assets 14,160 14.080 6.357 Total assets 38.407 41,209 38,407 41,209 equity What is the times interest earned ratio for 2021?
For the Year Ended December 31, 2020 Sales Revenue Cost of Goods Sold Gross Profit Operating Expenses Selling Expenses: Salaries Expense Rent Expense Advertising Expense Total Selling Expenses Administrative Expenses: Salaries Expense Insurance Expense Rent Expense Deprecaition Expense Total Administrative Expenses Total Operating Expenses Operating Income Other Income and Expenses Sales Discounts Forfeited 125,466 45,167 80,299 2,615 725 3,340 12,543 2,563 1,562 1,253 17,921 21,261 59,038 1,575 (265) Interest Expenses Total Other Income and Expenses Net Income 1,310 57.728 What type of financial statement is this? Statement of Owner's Equity Multiple-step Income Statement Balance Sheet O Single-step Income Statement
Calculate gross profit from the following? Sales of OMR 20000, Cost of goods sold OMR 8000 and Return inwards OMR 4000. a.OMR 24000 b.OMR 20000 c.OMR 8000 d.OMR 12000
Qe/ from the following tralasaction, prepar income Statement Sales reven ue tinished Goods V 50006 Net purchoses loo00 rent expenses 250 000 returns sales lo o00 So00 rent revenue 30oo administrutive Expensese 2e00 Sales salaries looo Depreriation other expensese tax income tooo +5006 finished goads 344 7o00 . tooo
Total Net Fixed Assets Total Assets O 14.97 siven, O 16.05 O 9.63 Cash Accounts Receivable Inventory Click to open: O 12.59 Net Sales Less: Cost of Goods Sold Less: Depriciation Earnings before Interest and Taxes O 10.12 Less: Interest Paid Taxable income Less: Taxes Net Income Precision Tools 2012 Income Statement ($ in Millions) What is the times interest earned ratio for 2012? 2011 2060 3411 18776 24247 14160 38407 LE 36408 28225 1760 6423 510 5913 2070 3843 Precision Tools 2011 and 2012 Balance Sheets ($ in Millions) 2012 1003 Accounts Payable 4218 Long Term Debt 21908 Common Stock 27129 Retained Earnings 14080 41209 Total Liabilities and Equity 2011 7250 9800 15000 6357 38407 2012 8384 11500 17500 3825 41209 97
Profit and Loss Account for the year ended 31st December 2021 (Figures are in £000) Particulars XYZ ABC Sales 3,690 4,586 Less: Cost of Goods Sold (Including purchases) (2,146) (2,690) Gross Profit 1,544 1,896 Less: Selling & Distribution Expenses Less: Depreciation (1,103) (1,253) Earnings before Interest & Tax or Operating Profit 441 643 Less: Interest (225) (192) Earnings before Tax 216 451 Less: Taxes (86) (180) Earnings after Tax or Net Profit 130 271 Balance Sheet as at31st December 2021 (Figures are in £000) Assets XYZ ABC Fixed Assets 4,542 4,790 Current Assets Account Receivables 274 313 Inventory 654 702 Cash 140 163 Total Current Assets 1,068 1,178 Total Assets 5,610 5,968 Liabilities Capital 3,824 4,310 Long Term Debt 883 760 Current Liabilities Account Payables…
Net sales CGS Operating expenses Determine the Gross profit and net profit 336500 132200 109000
Financial information is presented below: Operating Expenses $56000 Sales Revenue Cost of Goods Sold Gross profit would be $48000. $238000. $182000. $104000. 238000 134000