Question

In: Finance

The financial analyst at Medupe Company has prepared the following sales and cash disbursement estimates (in...

The financial analyst at Medupe Company has prepared the following sales and cash disbursement estimates (in thousand rand) for the period February to June of the current year

February March April May June
Sale 5000 6000 4000 2000 2000
Cash disbursement 4000 4000 6000 5000 3000

Historically Medupe Company has had 30% of sales being for cash. Of the credit sales, 70% are collected one month after the sale, and the remaining 30% are collected two months after the sale. The company has access to a R20000 revolving line of credit at a cost of 12% interest per year, assuming 365-day year. No administrative fees are applicable.

All purchases and other disbursements are procured on a cash basis. The depreciation for the year is estimated at R1 500 The beginning cash balance at April 1 is R1 500.

Required
Draw up a cash budget for Medupe Company for April, May and June and determine how much the requisite short-term financing by way of revolving line of credit will cost, if utilised.

February March April May June
Opening balance
Cash sales (30%)
Credit sales (70%)
February
March
April
May
June
Total credit sales
Cash disbursement
Cash in/(out) flow
Financing costs
Total financing cost

Solutions

Expert Solution

jeff jeffy answered 1 year ago
Next > < Previous

Related Solutions

The financial analyst for Sportif, Inc. has compiled sales and disbursement estimates for the coming months...
The financial analyst for Sportif, Inc. has compiled sales and disbursement estimates for the coming months of January through May. Historically, 75 percent of sales are for cash with the remaining 25 percent collected in the following month. The ending cash balance in January is $3,000. Month Sportif, Inc., Sales Disbursements January $5,000 $6,000 February 6,000 7,000 March 10,000 4,000 April 10,000 5,000 May 10,000 5,000 The total cash receipts for April are ________. The net cash flow for February...
1. (Identifying cash flows) An analyst has prepared the following data as part of a proposal...
1. (Identifying cash flows) An analyst has prepared the following data as part of a proposal to acquire a new machine: cost to purchase machine $40,000 cost to install machine 1,000 cost of new electric wiring 2,000 first year depreciation of machine 4,000 sales tax on purchasing machine 3,000 economic salvage value of the machine 10,000 accounting salvage value of the machine 8,000 a. Which of the above figures should enter the capital budgeting analysis? b. What figure should enter...
A financial analyst has been following Davis Inc., a new high-tech firm. He estimates that the...
A financial analyst has been following Davis Inc., a new high-tech firm. He estimates that the current risk-free rate (rF) is 6.25%, the market risk premium (rM - rF) is 5%, and the firm’s beta is 1.75. The current dividend just paid (D0) is $1.00. The analyst estimates that the company’s dividend will grow at a rate of 25% this year, 20% next year, and 15% the following year. After three years the dividend is expected to grow at a...
A financial analyst has been following Davis Inc., a new high-tech firm. He estimates that the...
A financial analyst has been following Davis Inc., a new high-tech firm. He estimates that the current risk-free rate (rF) is 6.25%, the market risk premium (rM - rF) is 5%, and the firm’s beta is 1.75. The current dividend just paid (D0) is $1.00. The analyst estimates that the company’s dividend will grow at a rate of 25% this year, 20% next year, and 15% the following year. After three years the dividend is expected to grow at a...
An analyst estimates that the enterprise value of a company is $6.4 billion. The firm has...
An analyst estimates that the enterprise value of a company is $6.4 billion. The firm has $900 million of debt outstanding and minority interest of $400 million. If there are 800 million shares outstanding, what is the analyst’s estimated value per share? $6.18 $6.28 $6.38 $6.48 From the following list of ten transactions, how many can be classified as investing? Common Stock Dividends Sales and marketing expenses Common stock repurchases Research and Development Expenditures Additions to property and equipment General...
A company is preparing completing their Cash Budget. The following data has been prepared for cash...
A company is preparing completing their Cash Budget. The following data has been prepared for cash receipts and payments. January February March Cash receipts $1,061,200 $1,182,400 $1,091,700 Cash payments 954,500 1,210,000 1,075,000 The company’s cash balance at January 1st is $290,000. This company desires a minimum cash balance of $340,000. What is the amount of excess cash or deficiency of cash (after considering the minimum cash balance required) for February?
The ABC Company has made the following monthly estimates of cash receipts and cash disbursements when...
The ABC Company has made the following monthly estimates of cash receipts and cash disbursements when preparing cash budgets for the next twelve months. ABC has beginning cash on hand of $25,000 and wants to maintain this minimum cash level throughout the next year. Cash Cash Month Receipts Disbursements January $100,000 $110,000 February $90,000 $110,000 March $95,000 $115,000 April $100,000 $150,000 May $130,000 $180,000 June $160,000 $180,000 July $200,000 $190,000 August $245,000 $180,000 September $245,000 $150,000 October $180,000 $120,000 November...
b) Dub's Records Stuff estimates its sales for the upcoming period and prepared the following budget:...
b) Dub's Records Stuff estimates its sales for the upcoming period and prepared the following budget: Units 25,000 Sales $20 Less variable costs: Manufacturing costs $3 Selling and administrative costs $2 Contribution margin $15 Less fixed costs: Manufacturing costs $14,000 Selling and administrative costs $12,000 Net income TBD Assuming the manager produced 190K in sales, 110K of total variable costs and 14K for total fixed costs for 15,000 units. Of these variable costs, 40K related to selling and administrative costs....
Alpine Products Company has made the following monthly estimates of cash receipts and cash disbursements when...
Alpine Products Company has made the following monthly estimates of cash receipts and cash disbursements when preparing cash budgets for the next twelve months. Alpine Products has beginning cash on hand of $10,000 and wants to maintain this minimum cash level throughout the next year Cash                            Cash Month             Receipts                       Disbursements January            $100,000                     $100,000         February          $90,000                     $110,000 March              $80,000                     $110,000 April                $100,000                     $150,000 May                 $120,000                     $180,000 June                 $160,000                     $180,000 July                 $200,000                     $180,000         August            $250,000                     $180,000         September       $250,000                     $150,000 October           $200,000                     $110,000...
A four-year financial project has estimates of net cash flows shown in the following table: Year...
A four-year financial project has estimates of net cash flows shown in the following table: Year Net Cash Flow 1 $20,000 2 25,000 3 30,000 4 35,000 It will cost $65,000 to implement the project, all of which must be invested at the beginning of the project. After the fourth year, the project will have no residual value. Using the most likely estimates of cash flows, conduct a discounted cash flow calculation assuming a 20 percent hurdle rate with no...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT