Question

In: Accounting

MILESTONE I: Complete the Cash Budget (Cash Receipts Schedule & Cash Payments Schedule) of Archer Electronics...

MILESTONE I: Complete the Cash Budget (Cash Receipts Schedule & Cash Payments Schedule) of Archer Electronics Company

Archer Electronics Company's actual sales and purchases for April and May are shown here along with forecast sales and purchases for June through September:

The company makes 20 percent of its sales for cash and 80 percent on credit. Of the credit sales, 50 percent are collected in the month after the sale and 50 percent are collected two months later. Archer pays for 20 percent of its purchases in the month after purchase and 80 percent two months after.

Labor expense equals 15 percent of the current month's sales. Overhead expense equals $12,500 per month. Interest payments of $32,500 are due in June and September. A cash dividend of $52,500 is scheduled to be paid in June. Tax payments of $25,500 are due in June and September. There is a scheduled capital outlay of $350,000 in September.

Archer Electronics' ending cash balance in May is $22,500. The minimum desired cash balance is $10,500. Prepare a schedule of monthly cash receipts, monthly cash payments, and a complete monthly cash budget with borrowing and repayments for June through September. The maximum desired cash balance is $50,500. Excess cash (above $50,500) is used to buy marketable securities. Marketable securities are sold before borrowing funds in case of a cash shortfall (less than $10,500).

MILESTONE II: Comprehensive time value of money

Dr. Harold Wolf of Medical Research Corporation (MRC) was thrilled with the response he had received from drug companies for his latest discovery, a unique electronic stimulator that reduces the pain from arthritis. The process had yet to pass rigorous Federal Drug Administration (FDA) testing and was still in the early stages of development, but the interest was intense. He received the three offers described in the following paragraph. (A 10 percent interest rate should be used throughout this analysis unless otherwise specified.)

OFFER I: $1,000,000 now plus $200,000 from year 6 through 15. Also if the product did over $100 million in cumulative sales by the end of year 15, he would receive an additional $3,000,000. Dr. Wolf thought there was a 70 percent probability this would happen.

OFFER 2: Thirty percent of the buyer's gross profit on the product for the next four years. The buyer in this case was Zbay Pharmaceutical. Zbay's gross profit margin was 60 percent. Sales in year one were projected to be $2 million and then expected to grow by 40 percent per year.

OFFER 3: A trust fund would be set up for the next eight years. At the end of that period, Dr. Wolf would receive the proceeds (and discount them back to the present at 10 percent). The trust fund called for semiannual payments for the next eight years of $200,000 (a total of $400,000 per year).

The payments would start immediately. Since the payments are coming at the beginning of each period instead of the end, this is an annuity due. Assume the annual interest rate on this annuity is 10 percent annually (5 percent semiannually). Determine the present value of the trust fund's final value. Hint: See the section on Annuities Due.

REQUIRED: Find the present value of each of the three offers and indicate which one has the highest present value.

Solutions

Expert Solution

Answer- 1:

Incomplete question as information about sales and purchases is missing.

Answer- 2:

OFFER- I:

Year

Cash Inflow

0

1000000

1 to 5

0

6 to 15

200000

15 (30000000 * .70)

2100000

NPV

$2,265,781.85

OFFER- II:

1

2

3

4

Sales

2000000

2800000

3920000

5488000

Gross Profit (60% of Sales)

1200000

1680000

2352000

3292800

Cash Inflows (30% of Gross Profit)

360000

504000

705600

987840

NPV

$1,948,637.39

OFFER- III:

Semi-annual Payment = $200,000

Total Payments = 16

Interest Rate = 5%

Future Value of Annuity = $200,000 * FVIFA, 5%, 16 Year

                                            = $200,000 * 24.8404

                                            = $4,968,080

Present Value of Final Amount = $4,968,080 * PVIF, 10%, 8 Years

                                                        = $4,968,080 * 0.46651

                                                       = $2,317,659

Offer 3 offers maximum worth.


Related Solutions

Use the schedule for cash receipts and the schedule for cash payments provided to complete a...
Use the schedule for cash receipts and the schedule for cash payments provided to complete a cash budget for M.K.H.M., Inc. Additional Information: M.K.H.M.’s beginning cash balance is $5,000 and M.K.H.M. desires to maintain a minimum ending cash balance of $5,000. M.K.H.M. borrows cash as needed at the beginning of each month in increments of $1,000 and repays the amounts borrowed in increments of $1,000 at the beginning of months when excess cash is available. The interest rates on amounts...
Archer Electronics is preparing its annual budget, and your department is working on the cash flow...
Archer Electronics is preparing its annual budget, and your department is working on the cash flow budget. Here is selected information you have: Description June July August Sales $348,000 $438,000 $450,000 The company makes 10% of its sales for cash and 90% on credit. Of the credit sales, 20% are collected in the month after the sale and 80% are collected two months after. The cash receipts for August are: A. Not enough information to solve the problem B. $326,000...
The following schedule of cash receipts and payments relates to Yellowstone, Inc. for the year 20X8:...
The following schedule of cash receipts and payments relates to Yellowstone, Inc. for the year 20X8: Cash receipts: From customers $348,000 From issuance of bonds payable 162,000 From sale of delivery truck 9,000 Cash payments: For purchase of equipment $ 70,800 To employees and suppliers 246,000 For interest expense 17,400 To shareholders for dividends 74,400 For purchase of treasury stock 14,400 For income taxes 21,600 Required: What is the cash flow from operations for Yellowstone, Inc. for 20X8?
Prepare a quarterly schedule of cash receipts budget for PEPSI Company for the year ended December...
Prepare a quarterly schedule of cash receipts budget for PEPSI Company for the year ended December 31, 2021, including the following schedules: Sales Budget (ALREADY DONE) & Schedule of Cash Receipts (NEED HELP WITH THIS) Pepsi Company Sales Budget For Year ended December 31,2021 Q1 Q2 Q3 Q4 Total Budgeted Sales in units 4,500 16,500 6,000 3,000 30,000 Selling Price per unit $290 $290.00 $290.00 $290.00 $290 Total budgeted sales $1,305,000 $4,785,000.00 $1,740,000.00 $870,000.00 $8,700,000 Relevant Info Dougs sales forecast...
Cash Receipts Budget and Accounts Receivable Aging Schedule Shalimar Company manufactures and sells industrial products. For...
Cash Receipts Budget and Accounts Receivable Aging Schedule Shalimar Company manufactures and sells industrial products. For next year, Shalimar has budgeted the following sales: Quarter 1 $4,610,000 Quarter 2 5,260,000 Quarter 3 6,510,000 Quarter 4 8,430,000 In Shalimar’s experience, 10 percent of sales are paid in cash. Of the sales on account, 65 percent are collected in the quarter of sale, 25 percent are collected in the quarter following the sale, and 7 percent are collected in the second quarter...
Cash Receipts Budget and Accounts Receivable Aging Schedule Shalimar Company manufactures and sells industrial products. For...
Cash Receipts Budget and Accounts Receivable Aging Schedule Shalimar Company manufactures and sells industrial products. For next year, Shalimar has budgeted the following sales: Quarter 1 $4,770,000 Quarter 2 6,000,000 Quarter 3 5,710,000 Quarter 4 8,010,000 In Shalimar’s experience, 10 percent of sales are paid in cash. Of the sales on account, 65 percent are collected in the quarter of sale, 25 percent are collected in the quarter following the sale, and 7 percent are collected in the second quarter...
Cash Receipts Budget and Accounts Receivable Aging Schedule Shalimar Company manufactures and sells industrial products. For...
Cash Receipts Budget and Accounts Receivable Aging Schedule Shalimar Company manufactures and sells industrial products. For next year, Shalimar has budgeted the following sales: Quarter 1 $4,690,000 Quarter 2 5,680,000 Quarter 3 1,820,000 Quarter 4 8,580,000 In Shalimar’s experience, 10 percent of sales are paid in cash. Of the sales on account, 65 percent are collected in the quarter of sale, 25 percent are collected in the quarter following the sale, and 7 percent are collected in the second quarter...
Cash Receipts Budget and Accounts Receivable Aging Schedule Shalimar Company manufactures and sells industrial products. For...
Cash Receipts Budget and Accounts Receivable Aging Schedule Shalimar Company manufactures and sells industrial products. For next year, Shalimar has budgeted the following sales: Quarter 1 $4,780,000 Quarter 2 5,270,000 Quarter 3 4,640,000 Quarter 4 7,620,000 In Shalimar’s experience, 10 percent of sales are paid in cash. Of the sales on account, 65 percent are collected in the quarter of sale, 25 percent are collected in the quarter following the sale, and 7 percent are collected in the second quarter...
Cornerstone Exercise 8.11 (Algorithmic) Cash Receipts Budget and Accounts Receivable Aging Schedule Shalimar Company manufactures and...
Cornerstone Exercise 8.11 (Algorithmic) Cash Receipts Budget and Accounts Receivable Aging Schedule Shalimar Company manufactures and sells industrial products. For next year, Shalimar has budgeted the following sales: Quarter 1 $4,670,000 Quarter 2 5,230,000 Quarter 3 2,850,000 Quarter 4 7,970,000 In Shalimar’s experience, 10 percent of sales are paid in cash. Of the sales on account, 65 percent are collected in the quarter of sale, 25 percent are collected in the quarter following the sale, and 7 percent are collected...
Cornerstone Exercise 8.11 (Algorithmic) Cash Receipts Budget and Accounts Receivable Aging Schedule Shalimar Company manufactures and...
Cornerstone Exercise 8.11 (Algorithmic) Cash Receipts Budget and Accounts Receivable Aging Schedule Shalimar Company manufactures and sells industrial products. For next year, Shalimar has budgeted the following sales: Quarter 1 $4,700,000 Quarter 2 5,230,000 Quarter 3 6,680,000 Quarter 4 8,590,000 In Shalimar’s experience, 10 percent of sales are paid in cash. Of the sales on account, 65 percent are collected in the quarter of sale, 25 percent are collected in the quarter following the sale, and 7 percent are collected...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT