Prepare a monthly cash budget

Assignment Help Accounting Basics
Reference no: EM133020927

Question - Company B has entered into the following transactions for the next six months

The board of the company wants to determine the short-term working capital funding needs of the company. The company has approached a bank to negotiate a line of credit.

This is a new venture with $10,000 of seed cash or opening cash.

Monthly sales are expected to be $50,000

The accounts receivable terms are 50% the month after sale and 50% in the second month after sale

Variable costs of sales are 40% and are paid the month following sale. The company operates under a just in time inventory system

Labor costs are 20% of sales and are paid monthly when the sale takes place

Overhead costs are 10% of sales and are paid in the following month

Debt servicing costs include the repayment of a loan of $15,000 and interest of $3,000 every 6 months starting in month 6.

The company will buy equipment for $600,000 in month 1 with $300,000 funded by long-term debt.

The company expects to obtain further long-term funding of $300,000 from the owners but not until month 3 and it needs to start production in month 1

Taxes of $12,000 will be deferred to month 12

Dividends of $5,000 will be paid in months 3 and 6 to the owners

Required -

1. Prepare a monthly cash budget?

2. How much is required to finance the business and when should the company pay it back?

Reference no: EM133020927

Questions Cloud

Do you agree with the accountant suggestion : An outside supplier has offered to provide Part X at a price of $54 per unit. Do you agree with the accountant's suggestion? Why
How many shares must be sold : The share currently sells for $8.00 and there are 150 million shares outstanding. How many shares must be sold if the subscription price is $7.50
What is the value of Goldman offer : Your alternative to this investment is an investment that will generate a 5.7% annually. What is the value of Goldman offer
What is the income tax result for martin : The surgery is unsuccessful, and after Cody's death, Martin sells the stock for $800,000. What is the income tax result for Martin
Prepare a monthly cash budget : The company will buy equipment for $600,000 in month 1 with $300,000 funded by long-term debt. Prepare a monthly cash budget
What amount of cash was received on the sale of accounts : The finance charge is 3%, and 5% was retained to cover sales discounts, What amount of cash was received on the sale of accounts receivable
How much is the balance of allowance for impairment loss : How much is the balance of allowance for impairment loss on December 31, 2023 immediately after impairment testing
Discuss adequacy of capital for retirement : They have a car ($30,000), home contents ($20,000) and savings ($20,000). Discuss adequacy of capital for retirement and show calculations
How much is forward contract debited or credited : Irving plc purchases some inventory from Durant SE for EUR 1 million on 7/1/21. How much is forward contract debited or credited on 7/1/21

Reviews

Write a Review

Accounting Basics Questions & Answers

  Discuss about cash flow statement

Discuss about Cash flow statement. Discuss what you learned about this statement and how it is related to the other financial statements.

  What position in the futures contracts should they take

A company has a portfolio of stocks worth £10 million. What position in the futures contracts should they take and how many contracts are needed

  What is the total cash paid for interest

What is the total cash paid for interest, income taxes, and total amount of Property and Equipment acquired on a non-cash basis on Amazon's 2018 10K

  What is the issue price of the bonds

January 1, 2017: Mega Corporation issued 10 year, 10% bonds with a face value of 2,575,000. What is the issue price of the bonds

  Make the appropriate adjustments to the statement

Using the columns provided on the income statement and balance sheet for Big Blue Rental Corp., make the appropriate adjustments/corrections to the statements

  What amount should phoenix report for sedona customer list

On January 1, 2011 Phoenix Co. acquired 100 percent of the outstanding voting shares of Sedona Inc. for $600,000 cash. At January 1 2011, Sedona's net assets had a total carrying amount of $420,000.

  Why does security market inefficiency suggest a measurement

Why does security market inefficiency suggest a measurement perspective? There is considerable theory on evidence that securities markets

  All operating expenses are fixed and are paid in the month

pendleton company a merchandising company is developing its master budget for 2013. the income statement for 2012 is as

  Determining the cost of assets

On March 1, Maria purchased a new laptop computer for her business at a cost of $1,850. Maria also purchased a new laser printer/photocopier combination at a cost of $840 on the same date. In April, Maria purchased computer software to use in he..

  Determine the inventory material and overhead costs

If the company's ending finished goods inventory of $791,100 included $24,100 of direct labour costs, determine the inventory's material and overhead costs

  How do calculate notes payable and investments

how do I calculate notes payable and investments

  What is the amount due on the note

MixRecording Studios signed a 60-day, 10% promissory note for $7,800. If the note is dishonored, what is the amount due on the note

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