Construct alphas cash budget and income statement

Assignment Help Cost Accounting
Reference no: EM13335007

The sales of Alpha Company in March were $92,000. The Balance sheet of Alpha Company (31 March) is given below.

Current Assets:


Cash

23,000

Accounts receivable

27,600

Merchandise inventory

93,200

Unexpired insurance

4,140

Total Current Assets

147,940

Gross fixed assets

85,100

Accumulated depreciation

-29,440

Net Fixed assets

55,660

Total Assets

203,600

Current Liabilities


Accounts payable

23,664

Accrued wages and commissions payable

5,835

Loan

0

Total Current Liabilities

29,499

Owner's equity

174,101

Total equity and liabilities

203,600



  • The projected sales in April and May are $110,000 and $184,000 respectively.
  • Alpha sales are 70% cash and 30% credit, collected in the following month. It has no currently overdue accounts and anticipates none in the future.
  • The company will purchase a second hand truck on 1 May 2008: $8,000
  • Miscellaneous cash expenses: 5% of the current sales
  • Rent: $4,600/month
  • Insurance expense: paid once a year (beginning of January) = $5,520;
  • Depreciation expense: $1,150/month
  • Tax rate: 0%
  • Wages: $5650/month + 15% commission of sales/month
  • 70% of the wages made in a specific month are paid in that month, the rests are paid in the following month)
  • The inventory policy of the company is to begin a month with a sufficient inventory to cover 80% of sales + $36,000 cushion
  • Cost of Goods Sold: 65% of sales
  • 60% of the purchases made in a specific month are paid in that month, the rests are paid in the following month).
  • Alpha borrowed from one of its founder at 1.5% interest/month for the next 2 years. Alpha borrows from and repays the founder at the end of the month. The agreement with this founder stipulates a $30,000 minimum cash balance in the venture's checking account.

Construct Alpha's cash budget, income statement, balance sheet and statement of cash flow for April.

Reference no: EM13335007

Questions Cloud

Determine the values using the equations and calculators : Find the following values using the equations and then a financial calculator. Compounding/discounting occurs annually. Round your answers to the nearest cent.
Process safety management of highly hazardous chemicals : Process Safety Management of Highly Hazardous Chemicals
What is going on in the financial industry today : What influences the demand for money? Who prints our money? How can our deposits expand in the banking system? What is deposit expansion multiplier? ? Is it easy to get loans from the banks these days? Tell us your experiences
Evaluate why mutual funds are an attractive investment : There are several ways that mutual funds can generate returns for investors. Compare and evaluate these different types of income and evaluate their tax effect.
Construct alphas cash budget and income statement : Construct Alpha's cash budget, income statement, balance sheet and statement of cash flow for April.
Determine the vector position of the center of mass : The vector position of a 3.80 g particle moving in the XY plane varies in time according to  \(r_1= (3i + 3j)t + 2t^2\), Determine the vector position of the center of mass at t = 2.90
Calculate the moment of inertia of the top : A 180 g top spinning at 14 rev/s makes an angle of 30° to the vertical and precesses at a rate of 1 rev per 8.0 s. what is the moment of inertia of the top
How to understand sql ddl and dml : Task one will provide a relational database implementation of the sample solution from the first assignment. This should be done using CASE software (the choice will be up to you).
What arguments would make for continuing regulatory : what arguments would you make for allowing insurers to set their own rates and be regulated by market or competitive forces. what arguments would you make for continuing regulatory approval of insurance rates.

Reviews

Write a Review

Cost Accounting Questions & Answers

  Create a segmented income statement in contribution format

Traceable fixed expenses totaled $216,000 and were allocated as 70 percent to Eastern and 30 percent to Western. Common fixed expenses totaled $295,000.

  Determine total net income if all products are sold

Stahl Inc. produces three separate products from a common process costing $100,000. Each of the products can be sold at the split-off point or can be processed further and then sold for a higher price. Shown below are cost and selling price data f..

  Calculate the fixed overhead production-volume variance

If the company were to prorate the variances, how much ($) of the direct material usage variance would be allocated to finished goods inventory?

  Calculate the sales-volume variance for each product

Calculate the sales-volume variance for each product and in total and calculate the sales-mix variance for each product and in total.

  Evaluate the amount of subscription revenue

Use the horizontal model to record the effects of the subsequent items Subscription fees received in advance in September 2010.

  Break-even point of using automated equipment

With an annual production rate of 5,000 units, how long will it take to reach break-even point of using automated equipment?

  What would you do in the ethical dilemma

The president says "hey, the life is only an estimate, and I've heard that our competition uses a 12-year life on their product equipment - What would you do

  How much loss can eric and denise recognize

The loan is secured by property with a $230,000 fmv. ed has a $200,000 ordinary loss during the current year. How much loss can eric and denise recognize?

  Brief description of the nossal institute for global health

Give a brief description of the Nossal Institute for Global Health (Nossal) and outline how climate change is likely to affect Nossal's business operations in developing countries.

  Evaluate how many units of product cedar

Evaluate how many units of product Cedar

  Determine the present value of the lease payments

Determine the present value of the lease payments at June 30, 2013 (to the nearest $000) that Georgia-Atlantic uses to record the leased asset and lease liability.

  Compute the firms predetermined overhead rate

Why is calculating the predetermined overhead rate so important and compute the firm's predetermined overhead rate.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd