Alpaca Corporation had revenues of $250,000 in its first year of operations. The company has not collected on $18,900 of its sales and still owes $27,000 on $96,000 of merchandise it purchased. The company had no inventory on hand at the end of the year. The company paid $12,700 in salaries. Owners invested $14,000 in the business and $14,000 was borrowed on a five-year note. The company paid $3,800 in interest that was the amount owed for the year, and paid $7,800 for a two-year insurance policy on the first day of business. Alpaca has an effective income tax rate of 40%. (Assume taxes are paid in the same year). Compute the cash balance at the end of the first year for Alpaca Corporation.

$84,360.00  

Explanation:

The cash balance at the end of the year is simply total cash receipts minus total cash payments which is further analyzed below:

Cash receipt from sales=total sales-accounts receivable=$250,000-$18,900=$ 231,100.00  

Cash paid for merchandise purchase=purchases-accounts payable=$96,000-$27,000=$69,000

Salaries paid     $12,700

Cash from  owners is $14,000

cash from borrowing is $14,000

interest paid is $3800

insurance paid is $7,800

Tax paid=(sales-purchases-salaries paid-insurance cost(one year)-interest paid)*tax rate

insurance for one year=$7800*1/2=$3,900

tax paid=($250,000-$96,000-$12,700-$3,800-$3,900)*40%=$53440

Cash balance=$231,100-$69,000-$12,700+$14,000-$14,000-$3800-$7800-$53440=$84,360.00