Make a cash budget for the first quarter of the year

Assignment Help Financial Accounting
Reference no: EM132992438

Collection method is half in the month of sales and another half in the following month.

Monthly sales: RM200,000 January, RM240,000 February, RM 250,000 March.

Cash purchases: RM30,000 January, RM40,000 February, RM 50,000 March.

Credit Purchase: RM20,000 January, RM20,000 February, RM 30,000 March. Payment made in the following month of purchase.

  • Rent and salary paid RM20,000 and RM30,000 each month.
  • A loan received from ABM Financing at the beginning of the year in January is RM20,000. This loan will be paid at the beginning of March with interest of 10% per month.
  • Bought Furniture RM5,000, a deposit paid in cash RM2,000 in February. The full settlement will be made following month.
  • Bank balance on the last day of December last year was RM12,000.

Required:

Problem 1: Prepare a cash budget for the 1st Quarter of the year.

Reference no: EM132992438

Questions Cloud

Analyse terms of capital market response to unexpected : Critically analyse the article in terms of capital market response to unexpected announcements. Vodafone was the biggest faller on the FTSE 100 on Tuesday
Determine the budgeted fixed overhead : If actual fixed overhead £120,000 and there a £2,600 favorable spending variance and £2,000 unfavorable volume variance, determine the budgeted fixed overhead
How much was the bad debt expense the year : Let's suppose you own a company. Given that the actual write-off was $6 million in 2020, how much was the bad debt expense this year?
What are the nominal and effective costs of trade credit : What are the nominal and effective costs of trade credit under the credit terms of 2/15, net 30? Assume a 365-day year
Make a cash budget for the first quarter of the year : Monthly sales: RM200,000 January, RM240,000 February, RM 250,000 March. Prepare a cash budget for the 1st Quarter of the year.
How much would the company save annually : Currently the purchasing agent is paying each invoice in 25 days. If payment is delayed until the 30th day, how much would the company save annually
Prepare the company functional-form income statement : Prepare the company's functional-form Income Statement for the fiscal year ended September 30, 2021. Journalize adjusting entries on September 30, 2021.
What is the opportunity cost of capital : What is the opportunity cost of capital and does that make Bob's Golf Clubs' investment a good idea under the circumstances
How much does the company need in external funds : Based on the sales growth forecast, how much does the company need in external funds for the upcoming fiscal year using the EFN equation

Reviews

Write a Review

Financial Accounting Questions & Answers

  Calculate the receivables turnover ratio for the year

Universal Sports Supply began the year with an accounts receivable balance of $160,000 and a year-end balance of $180,000. Credit sales of $580,000 generate a gross profit of $280,000. Calculate the receivables turnover ratio for the year

  What is the amount of cash paid to bondholders for interest

Give the journal entry made by Olsen Products on April 1 , Year 2 , to record the semiannual payment of interest to bondholders

  How much is the foreign gain or loss

The selling spot rate is FC to P74.85. On January 30, the selling spot rate is FC to P75.75. On the settlement date, how much is the foreign gain or loss?

  Prepare Pearl Corporation journal entries for the investment

Sapphire reported net income of $525,000. Prepare Pearl Corporation's journal entries for the investment in Sapphire for the 2021 fiscal year

  What amount on may iris will receive

Iris Investor owns 500 shares, purchased on April 1, 2021. Iris sells all of her shares on May 15. Iris will receive what amount on May 25th?

  How much cash from march sales was collected in april

How much cash from March sales was collected in April? Credit sales are collected as follows: 70% in the month of sale and 30% in the month after sale.

  Journal entries to record investmentscrane mechanics

journal entries to record investments.crane mechanics acquired 75 percent of downey enterprises on march 31 2005 for

  Provide one recommendation for milo ltd to improve gross

Explain the possible reasons for the differences in approach between the two businesses. Provide one recommendation for Milo Ltd to improve its gross margin.

  Evaluate tims 2012 cost recovery deduction

Evaluate Tim's 2012 cost recovery deduction (Consider Tim did not make a section 179 election and elected out of bonus depreciation). Show your work and describe your calculations.

  In what year will payback occur

A company is considering investing $90,000 in a project with the following anticipated net cash flows: In what year will payback occur

  Which investor would considered the superior stock selector

If the T-bill rate was 8% and the market return during the period was 12%, which investor would be considered the superior stock selector

  What is the basic earnings per common share

$100,000 on its common stock. The basic earnings per common share, rounded to the nearest cent, for the year ended December 31, 2011, should be

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