2 You currently have a cash balance of $140,000, receivables of $220,000 and payables of $90,000. Average days in receivables is 30 and average days in payables is 42. You typically order 50% of next quarter's predicted sales in raw materials which is your variable cost. Salaries and other related costs typically amount to 20% of your current period sales. Last year's sales were as detailed below by quarter. You expect an increase of 5% year on year on last year's sales. Q1 400,000 Q2 410,000 Q3 430,000 Create a cashflow prediction by quarter for the next four quarters. Q4 400,000

2 You currently have a cash balance of $140,000, receivables of $220,000 and payables of $90,000. Average days in receivables is 30 and average days in payables is 42. You typically order 50% of next quarter's predicted sales in raw materials which is your variable cost. Salaries and other related costs typically amount to 20% of your current period sales. Last year's sales were as detailed below by quarter. You expect an increase of 5% year on year on last year's sales. Q1 400,000 Q2 410,000 Q3 430,000 Create a cashflow prediction by quarter for the next four quarters. Q4 400,000

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

The Titan Company provides you with the following information for the current year: Revenues = $2,000,000Cost of goods sold = $750,000 (2/3 of this amount varies with the number of units produced)S&A costs = $200,000 (1/2 of this amount is fixed)Selling price = $40 per unit The company sold 50,000 units of their product in the current year. The company expects unit sales of their product to increase 20% in the next year. Based on the information above, what would be the expected increase to profit before taxes in the coming year?
At a furniture factory, the average selling price of a table is $18, the average variable expense per table is $ 9, and the average fixed expense per month is $12,000. On average 2,000 tables are sold at each month. If sales increase by 20%, by how much should net operating income increase? A. $ 7,200 B. $ 10,000 C. $ 8,000 D. $ 3,160
Ma1.
A company is considering switching from a cash only policy to a net 30 credit policy. The price per unit is $700 and the variable cost per unit is $600. The company currently sells 1,000 units per month. Under the proposed policy the company expects to sell 1,200 units per month. The quarterly compounded APR is 15%. If you were using NPV analysis to decide whether the company should switch to the net 30 (1-month) credit policy, what amount would you use for the present value of the incremental cash flows?
EFU Group is considering changing its credit period from “net 45" (which has resulted in 8 A/R "Turns" per year) to "net 60" (which is expected to result in 6 A/R “Turns" per year). EFU Group is currently producing a single product with variable costs of $150 and a selling price of $180. Additional annual credit sales of $180,000 from new customers are forecasted, in addition to the current $1.5 million in annual credit sales. The before-tax opportunity cost for each dollar of funds "tied-up" in additional receivables is 30%. Ignoring any additional bad-debt losses that may arise, should EFU Group relax their credit period?
A Company manufactures and sells stationary. Last year, the stationary it sold for £15 each, andthe variable expense was £4.50 per unit. The company needed to sell 20,000 of stationary tobreak even. The operating profit last year was £16,800. The Company anticipations for thecoming year include the following: The selling price per stationary will be £18.00.Variable expenses will increase by one third. Fixedexpenses will increase by 10 per cent.If company wishes to earn £45,000 in operating profit for the coming year, the company's salesvolume in pounds must be: A. £ 427,500 B. £ 515,250 C. £ 414,000 D. £ 459,000
ABC Corporation sells its product for $12 per unit. Next year, fixed expenses are expected to be $400,000 and variable expenses are expected to be $8 per unit. How many units must the company sell to generate a target profit (net operating income) of $80,000?
Suppose you sell 8,000 of the 3 pack of lenses described in question 3 above in one year. You cost on each 3 pack is $29.95 and you sell them for $59.95. If your operating expenses for the year total $144,080, what are your Net Income and Net Profit Margin Percentage?
A company reported the following data: • Sales price per unit: $10 • Fixed cost per month: $20,000 Variable cost per unit: $2 How many units must this company sell each month in order to reach a target profit of $50,000?
A Mobile shop sells 5000 mobiles in a year and the sales is relatively constant throughout the year. These mobiles are purchased for SR 150.00 each, and the lead time is two days. The holding cost per mobile per year is 6% of the unit cost and the ordering cost per order is SR 37.50. There are 250 working days per year. Calculate the following: (i) What is the annual holding cost? (ii) In minimizing the cost, how many orders would be made each year? (iii) Given the EOQ, what is the total annual inventory cost (including purchase cost)? (iv) What is the time between orders? (v) What is the ROP?
A 50-room hotel has an ADR of $140 per room, variable cost of $25 per room and monthly fixed costs of $100,000. The average occupancy rate is equal to 60%. What is total monthly revenue equal to at the break-even point?
A Company manufactures and sells stationary. Last year, the stationary it sold for £15 each, andthe variable expense was £4.50 per unit. The company needed to sell 20,000 of stationary tobreak even. The operating profit last year was €16,800. The Company anticipations for thecoming year include the following:The selling price per stationary will be £18.00. Variable expenses will increase by one third. Fixedexpenses will increase by 10 per cent. Sales for the coming year are expected to exceed last year's by 1,000 units. If this occurs,sales volume in the coming year will be: A. 22,600 B. 21,960 C. 23,400 D. 21,000