INCOME STATEMENT FOR ALPINE TRADERS FOR 3MONTHS MarchR1 800ACTIVITY 7.16INSTRUCTIONMake use of the following information to prepare a projected Income Statement for Alpine Traders forthe 3 month period 1 January 20.8 to 31 March 20.8.INFORMATION:SUMMARY OF THE INCOME STATEMENT FOR THE YEAR ENDED31 DECEMBER 20.7SalesCost of salesRent IncomeSalaries and WagesAdvertisingInterest on Mortgage LoanDepreciation on equipmentOther sundry expenses720 000480 00012 00096 00018 60024 0007 00055 000 ADJUSTMENTS AND ADDITIONAL INFORMATION:1. Total sales are expected to increase by 10% during 20.8.2. There will be a 100% mark up on cost of sales in the New Year.3. Monthly rent will be increased to R1 300 as from 1 March 20.8.4. Salaries and wages are due to increase by 15% as from 1 January 20.8.5. Management has decided to double the amount to be spent on advertisingduring 20.8.6. A quarter of the capital of the mortgage loan was repaid on 31 December20.7. The rate of interest remains the same for 20.8.7. The annual depreciation on equipment is expected to be R12 000 for 20.8.8. Other sundry expenses are expected to increase by R17 000 during 20.8.ACTIVITY 7 17

Projected Income Statement describes the information about the projection of revenue and expenses…

Make use of the following information to prepare a projected Income Statement for Alpine Traders for the 3 month period 1 January 20.8 to 31 March 20.8. INFORMATION: SUMMARY OF THE INCOME STATEMENT FOR THE YEAR ENDED 31 DECEMBER 20.7 Sales Cost of sales Rent Income Salaries and Wages Advertising Interest on Mortgage Loan Depreciation on equipment Other sundry expenses 720 000 480 000 12 000 96 000 18 600 24 000 7 000 55 000

Make use of the following information to prepare a projected Income Statement for Alpine Traders for the 3 month period 1 January 20.8 to 31 March 20.8. INFORMATION: SUMMARY OF THE INCOME STATEMENT FOR THE YEAR ENDED 31 DECEMBER 20.7 Sales Cost of sales Rent Income Salaries and Wages Advertising Interest on Mortgage Loan Depreciation on equipment Other sundry expenses 720 000 480 000 12 000 96 000 18 600 24 000 7 000 55 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

1. A company has a sales plan for 2020 based on the estimated end of the month as follows: Month Total sales July Rp 28.000,00 August 35.000,00 September 42.000,00 Payment terms are set: 3/20/net 30. Based on the experience of the customer's payment method as follows: 60% of sales every month is collected at 20 days after the month of pend. 30% accumulated in the time after 20 days in the same month, i.e. in the first month after the month of Dec. 10% collected in the second month after the month of Dec. Required: prepare a schedule/budget for collection of receivables (receivables collection budget)
Lewellen Products has projected the following sales for the coming year: 01 02 03 04 Sales $940 $1,020 $980 $1,080 Sales in the year following this one are projected to be 20 percent greater in each quarter a. Calculate payments to suppliers assuming that the company places orders during each quarter equal to 30 percent of projected sales for the next quarter. Assume that the company pays immediately. What is the payables period in this case? (Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16.) b. Calculate payments to suppliers assuming a 90-day payables period. (Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16.) c. Calculate payments to suppliers assuming a 60-day payables period. (Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16.) a. b. Payment of accounts Payment of accounts Payment of accounts 01 02 Q3 Q4
Revenue (£k) 200 175 150 125 100 75 50 25 0 73 96 130 149 Jan Feb 152 Mar Apr May 133 Jun Jul 140 Aug 145 Sep Oct Nov 150 Dec 155 Your manager has provided you with the revenue figures for last year. He has informed you that the target is to increase amount of products you sold in January last year by 50%. Based on the data provided, what would be your estimated target figure for this January? 178 200
5) If a company pays its sales force the following for its sales in the last two years, what is the annual fixed cost per sales dollar? alendar Sales force salary 152,500 175,000 If the company employs 3 salespeople, what is the average salary in a year where they sell $2,750,000?
Jim's Espresso expects sales to grow by 10.4% next year. Using the following statements LOADING... and the percent of sales method, forecast: a. Costs b. Depreciation c. Net Income d. Cash e. Accounts receivable f. Inventory g. Property, plant, and equipment (Note: Make sure to round all intermediate calculations to at least five decimal places.) The Tax Cuts and Jobs Act of 2017 temporarily allows 100% bonus depreciation (effectively expensing capital expenditures). However, we will still include depreciation forecasting in this chapter and in these problems in anticipation of the return of standard depreciation practices during your career. Income Statement Sales $207,620Costs Except Depreciation (100,360)EBITDA $107,260Depreciation (6,050)EBIT $101,210Interest Expense (net) (500)Pretax Income $100,710Income Tax (35,249)Net Income $65,461 Balance Sheet Assets Cash and Equivalents $14,990Accounts Receivable 1,980Inventories…
Sexton Products has projected the following sales for the coming year: Q1 Q2 Q3 Q4 Sales $ 930 $ 1,010 $ 970 $ 1,070 Sales in the year following this one are projected to be 10 percent greater in each quarter. a. Calculate payments to suppliers assuming that the company places orders during each quarter equal to 30 percent of projected sales for the next quarter. Assume that the company pays immediately. (Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16.) b. Calculate payments to suppliers assuming a 90-day payables period. (Do not round intermediate calculations and round your answers to 2 decimal places, e.g ., 32.16.) c. Calculate payments to suppliers assuming a 60-day payables period. (Do not round intermediate calculations and round your answers to 2 decimal places, e. g., 32.16.)
Sanchez, Incorporated, is considering a change in its cash-only sales policy. The new terms of sale would be net one month. The required return is 1.7 percent per month. Current Policy New Policy Price per unit $ 700 $ 700 Cost per unit $ 420 $ 420 Unit sales per month 1,120 1,220 Based on the above information, determine the NPV of the new policy.
1-a. How much will net operating income increase (decrease) per month if the monthly advertising budget increases by $5,000, the monthly sales volume increases by 100 units, and the total monthly sales increase by $9,000? 1-b. Should the advertising budget be increased?
1-a. How much will net operating income increase (decrease) per month if the monthly advertising budget increases by $8,100 and monthly sales increase by $14,400?
Digby's turnover rate for this year is 6.36%. This rate is projected to remain the same next year and no further downsizing will occur from automating. Digby plans to spend an additional $500 beyond the extra amount above the $1000 recruiting base it spent this year. The goal of this additional investment is to improve the quality of applicants. What would the total recruiting cost be for Digby next year? Select : 1 $186,185 $171,863 $157,541 $143,219
Sexton Products has projected the following sales for the coming year: Q1 Q2 Q3 Q4 Sales $920 $1,000 $960 $1,060 Sales in the year following this one are projected to be 15 percent greater in each quarter. a. Calculate payments to suppliers assuming that the company places orders during each quarter equal to 30 percent of projected sales for the next quarter. Assume that the company pays immediately. (Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16.) b. Calculate payments to suppliers assuming a 90-day payables period. (Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16.) c. Calculate payments to suppliers assuming a 60-day payables period. (Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16.) a. Payment of accounts b. Payment of accounts c. Payment of accounts Q1 Q2 Q3 Q4
Projector Limited has the following projection for the 4 months ending August 2018:MayJuneJulyAugustR’sR’sR’sSales320 000380 000420 000460 000Purchases160 000160 000230 000250 000Rent income11 00011 000??Salaries26 80026 800??1. 50% of the sales are for cash and the balance is on credit.2. All credit sales are collected one month after the sale.3. All purchases are on credit. Creditors are paid in full one month after the month of purchase.4. The tenants rent contract stipulates an increase of 20% from 1 July 2018.5. Salaries are expected to increase to R32 000 per month as at 1 August 2018.6. A new motor vehicle will be purchased during June 2017. Repayments of R6 000 per month will commence on 1 July 2017.7. Advertising costs are expected to be 2% of sales from 1 June 2018.8. A fixed deposit of R25 000 will mature in the month of July 2018.9. On 31 May 2018, the bank is expected to have a favourable balance of R420 000.Required:Prepare a Cash Budget for the three (3) months ending…