In: Accounting
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.
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.