Ask Managerial Accounting Expert

Cash budget comprehensive Following are the budgeted income statements for the second quarter of 2013 for SeaTech, Inc.:

The company expects about 30% of sales to be cash transactions. Of sales on account, 60% are expected to be collected in the first month after the sale is made, and 40% are expected to be collected in the second month after sale. Depreciation, insurance, and property taxes represent $12,000 of the estimated monthly cost of goods sold and $8,000 of the estimated monthly operating expenses. The annual insurance premium is paid in January, and the annual property taxes are paid in August. Of the remainder of the cost of goods sold and operating expenses, 80% are expected to be paid in the month in which they are incurred, and the balance is expected to be paid in the following month.
Current assets as of April 1, 2013, consist of cash of $14,000 and accounts receivable of $149,800 ($105,000 from March credit sales and $44,800 from February credit sales). Current liabilities as of April 1 consist of $18,000 of accounts payable for product costs incurred in March; $4,600 of accrued liabilities for operating expenses incurred in March; and a $40,000, 12%, 120-day note payable that is due on April 17, 2013.
An estimated income tax payment of $40,000 will be made in May. The regular quarterly dividend of $16,000 is expected to be declared in May and paid in June.
Capital expenditures amounting to $17,200 will be made in April.

Required:
a. Complete the monthly cash budgets for the second quarter of 2013 using the following format. Note that the ending cash balance for June is provided as a check figure.
b. Assume that management of SeaTech, Inc., desires to maintain a minimum cash balance of $10,000 at the beginning of each month and has arranged a $50,000 line of credit with a local bank at an interest rate of 10% to ensure the availability of funds. Borrowing transactions are to occur only at the end of months in which the budgeted cash balance would otherwise fall short of the $10,000 minimum balance. Repayments of principal and interest are to occur at the end of the earliest month in which sufficient funds are expected to be available for repayment. 

Explain how this minimum cash balance requirement would affect the monthly cash budgets prepared in parta. 

Managerial Accounting, Accounting

  • Category:- Managerial Accounting
  • Reference No.:- M91585391
  • Price:- $15

Priced at Now at $15, Verified Solution

Have any Question?


Related Questions in Managerial Accounting

Instructions for preparation of assignment1 you are to

Instructions for Preparation of Assignment: 1. You are to choose one management accounting topic from the list below for this assignment, and register your chosen topic with your lecturer in class or via email before com ...

Management accounting assessment - research amp analysis

Management Accounting Assessment - Research & Analysis Teamwork Assessment Description - Learning Outcome - Analyse the issues or problems (in a given scenario) using management accounting techniques and tools, and formu ...

Management accounting with a strategic perspective

MANAGEMENT ACCOUNTING with a STRATEGIC PERSPECTIVE Assignment - This Assignment is designed to give students an opportunity to: 1. Integrate traditional, contemporary and advanced theoretical and technical management acc ...

Corporate accounting assignment -assessment task - select

Corporate Accounting Assignment - Assessment task - Select two public limited companies listed on the Australian Securities Exchange (ASX) that are in the same industry. Go to the website of your selected companies. Then ...

You need to prepare a paper about lacroix companycompany

You need to prepare a paper about Lacroix company Company: Lacroix Home Work: History & background Page: 1 and half

Managerial accounting assignment -background you are

Managerial Accounting Assignment - Background: You are recently employed as a graduate consultant in a management consultancy firm and are assigned to a team. One of your firm's clients is currently evaluating its budget ...

Managerial accounting assignment -background you have been

Managerial Accounting Assignment - Background: You have been hired by the Board of Directors of your chosen company (ASX Listed) to explain how ABC model can improve the management accounting information available to its ...

Assume you have been hired as a consultant to prepare a

Assume you have been hired as a consultant to prepare a balanced scorecard that will be presented to top management. You will choose a company to research and will provide a professional report that will include the foll ...

Accounting for decision makersproject - appendix

Accounting for Decision Makers PROJECT - APPENDIX A Requirements: 1. Choose a publicly traded company that you currently own/invest in or one that you would like to own / invest in 2. Research the company through the com ...

Task descriptionyou have gained a position as vacation

Task Description You have gained a position as vacation student at the accounting firm T&K Solutions. In your capacity of vacation student you have been asked by the two partners of T&K Solutions to assist them with two ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As