70.2K

Verified Solution

Link Copied!

I. Problem-Solving The following accounts of Mezzo HealthCare Co. were found on Dec 31.

Cash 10,000 Marketable Securities 20,000 Accounts Receivable 15,000 Allowance for bad debts 1,000 Inventory 8,000 Equipment 50,000 Accumulated depreciation 5,000 Long-term investments 20,000 Accounts Payable 23,000 Accrued Expenses 7,000

Cash Sales 20,000 Credit Sales 80,000 Net Purchases 30,000 Cost of Goods Sold 50,000 Net Income After Tax 40,000

Compute for the following: a. Current ratio b. Quick ratio c. Working Capital d. Asset turnover e. Fixed asset turnover f. Accounts Payable Turnover g. Asset Turnover h. Accounts Receivable Turnover i. Inventory Turnover j. Debt to Total Asset Ratio k. Gross Profit Margin

II. Prepare horizontal and vertical analysis for the following data. 2020 2019 2018 Sales 6,000,000 5,000,000 5,600,000 Sales Discount 15,000 20,000 12,000 Current Assets 3,000,000 2,200,000 2,600,000 Non-Current Assets 8,000,000 10,000,000 6,500,000 Unearned Revenue 300,000 255,000 315,000 Accrued Expenses 115,000 200,000 230,000 III. Compute the break-even in units and in pesos in each of the following: a. The variable cost is of the sales revenue. Each unit of product is sold for P50. The fixed costs amounted to P300,000. b. The fixed costs amounted to 350,000. Each unit sold contributes P8 to the recovery of fixed costs and profit. Selling price per unit is P15. c. Contribution margin is equal to 30% of the revenue. Each unit of product sells for P300. The fixed costs amounted to P700,000.

IV. The following are gathered for HeHe Inc. Sales 1,400,000 Variable Costs 560,000 Fixed Costs 800,000 Net Income 40,000 Selling price per unit 20 a. Compute the break-even sales in units and in pesos b. Compute the sales volume needed for a desired net income of 150,000.

V. Last year Simbulan Co had a unit selling price of P20. Its unit variable cost was P14. Its fixed costs amounted to 95,000. Compute the anticipated break-even sales in units and in pesos. VI. Aldo Inc is targeting a 100% increase in its existing profit. Its present income is P80,000. Each product is sold for P80 per piece. Variable cost per unit is P50 while fixed costs are P200,000. What is the breakeven point in units and pesos?

VII. True or False 1. At break-even point, contribution margin is equal to fixed costs. 2. If contribution margin is greater than fixed cost, a loss occurs. 3. Selling price per unit minus variable costs per unit is contribution margin ratio. 4. Fixed costs divided by the contribution margin per unit is the break-even point in units. 5. To compute variable costs, the number of units is multiplied to variable cost per unit. 6. Sales budget is necessary to prepare production budgets. 7. Cost-volume-profit analysis is the process of determining the best or the better choice between alternatives.

(PLEASE WRITE DOWN ANSWERS ONLY IN EXCEL FORMAT, THANK YOU FOR YOUR TIME)

Answer & Explanation Solved by verified expert

See Answer