Eagle Security Pte Ltd is a leading security company in Singapore. As at 1 January 2023,...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Eagle Security Pte Ltd is a leading security company in Singapore. As at 1 January 2023, its cash at bank balance is $250,000. The company's policy is to maintain a minimum cash balance of $100,000. The company is developing a cash budget for January, February and March 2023, and the following information was gathered: Cash Receipts Fee revenue for November and December 2022 are $210,000 and $170,000 respectively. The forecasted billings for January, February and March 2023 are $180,000, $210,000 and $260,000 respectively. Historically, 10% of the company's billings are in cash, 70% are collected in the next month, and the remaining 20% are collected in the second month following the sale. Dividend income of $C0,000 will be received in February 2023. (C is the 6th digit of your admin number). 2 (Use $60,000 if the 6th digit of your admin number is 0) 3 Interest income of $2,000 will be received in March 2023. Cash Disbursements 4 Rental payment was $10,000 per month. In March 2023, this would be increased to $15,000 per month. 5 Fixed monthly salaries paid is $110,000. Variable salaries are paid at D% of the previous month's fee revenue. (D is the 7th digit of your admin number). (Use 7% if the 7th digit of your admin number is 0) Payment for new security equipment amounting to $350,000 is scheduled for payment in March 2023. Use the following templates to prepare the cash budget for January, February and March 2023: a) Projected Cash Receipts Receipts Fee revenue Collections from billings: Within same month (10%) Lag 1 month (70%) Lag 2 months (20%) Dividend income ($C0,000) Interest income Total Cash Receipts b) Projected Cash Disbursements Disbursements Rental Salaries Variable salaries (D%) Equipment Total Cash Disbursements c) Cash Budget Total cash receipts Less: Total cash. disbursements Net cash flow Add: Beginning cash Ending cash Minimum cash Dec Nov $ $ 210,000 170,000 Required Financing Excess Cash Balance Jan $ Jan $ Feb $ 180,000 210,000 Jan $ Feb $ Feb $ Mar $ 260,000 Mar $ Mar $ (13 marks) (8 marks) (9 marks) Eagle Security Pte Ltd is a leading security company in Singapore. As at 1 January 2023, its cash at bank balance is $250,000. The company's policy is to maintain a minimum cash balance of $100,000. The company is developing a cash budget for January, February and March 2023, and the following information was gathered: Cash Receipts Fee revenue for November and December 2022 are $210,000 and $170,000 respectively. The forecasted billings for January, February and March 2023 are $180,000, $210,000 and $260,000 respectively. Historically, 10% of the company's billings are in cash, 70% are collected in the next month, and the remaining 20% are collected in the second month following the sale. Dividend income of $C0,000 will be received in February 2023. (C is the 6th digit of your admin number). 2 (Use $60,000 if the 6th digit of your admin number is 0) 3 Interest income of $2,000 will be received in March 2023. Cash Disbursements 4 Rental payment was $10,000 per month. In March 2023, this would be increased to $15,000 per month. 5 Fixed monthly salaries paid is $110,000. Variable salaries are paid at D% of the previous month's fee revenue. (D is the 7th digit of your admin number). (Use 7% if the 7th digit of your admin number is 0) Payment for new security equipment amounting to $350,000 is scheduled for payment in March 2023. Use the following templates to prepare the cash budget for January, February and March 2023: a) Projected Cash Receipts Receipts Fee revenue Collections from billings: Within same month (10%) Lag 1 month (70%) Lag 2 months (20%) Dividend income ($C0,000) Interest income Total Cash Receipts b) Projected Cash Disbursements Disbursements Rental Salaries Variable salaries (D%) Equipment Total Cash Disbursements c) Cash Budget Total cash receipts Less: Total cash. disbursements Net cash flow Add: Beginning cash Ending cash Minimum cash Dec Nov $ $ 210,000 170,000 Required Financing Excess Cash Balance Jan $ Jan $ Feb $ 180,000 210,000 Jan $ Feb $ Feb $ Mar $ 260,000 Mar $ Mar $ (13 marks) (8 marks) (9 marks)
Expert Answer:
Answer rating: 100% (QA)
Based on the information provided heres how to fill out the cash budget for January February and March 2023 a Projected Cash Receipts To calculate the ... View the full answer
Related Book For
Intermediate Accounting IFRS
ISBN: 9781119607519
4th Edition
Authors: Donald E. Kieso, Jerry J. Weygandt, Terry D. Warfield
Posted Date:
Students also viewed these accounting questions
-
3. Calculate the work done, W=mgh for a mass of 300 g. Then, using the accepted value for the specific heat of water, calculate the change in heat, Q=cmAT for the same data point. a) Calculate the...
-
Mischa Furniture Stores (MFS) is a company that specializes in office furniture based in Windhoek. Due to the effects of Covid-19, it has become very imperative for the company to manage its cash...
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
Products are 1. Lip gloss or lipstick with SPF 2. Custom facial sheets you can make online or in store pickup and have it send to your home based on your needs 3. A foundation sunscreen Price Provide...
-
In a volcanic eruption, 4 km 3 of mountain with a density of 1600 kg/m 3 was lifted an average height of 500 m. (a) How much energy in joules was released in this eruption? (b) The energy released by...
-
How should managers dispose of under- or overallocated manufacturing overhead costs at the end of the accounting year?
-
The trial balance of Seth Knoll, CPA, P.C., is dated November 30, 2011: During December, Knoll or his business completed the following transactions: Requirements 1. Record the December transactions...
-
You are given the following information concerning four stocks: a) Using 20X0 as the base year, construct three aggregate measures of the market that simulate the Dow Jones Industrial Average, the...
-
Using the Expected Utility Theory answer the following question. You are late for a party and are thinking about which store to visit on the way, to buy a drink to bring with you. Suppose: Your...
-
In August 2007 and in March 2008, the Federal Reserve Board reduced the discount rate to ease liquidity conditions for banks. Plot discount window borrowing (FRED code: DISCBORR) between January 2007...
-
1. If our Economic System was Plain or Simple would it be prosperous? Explain Give example and Situation 2. If the only thing that drives the Economy of a country is the House of Commerce and the...
-
What happens if you assume the expenses incurred will remain the same as the percentage of sales, but they don't? Discuss.
-
You know that average returns on the stock market have ranged between about 8% and 12% per year in recent decades. So when someone on reddit claims that there is an investment that can give you a...
-
1. For this final project, you are required to develop a BookStock System in Java, so that books can be stored in the system for such as the book title, ISBN number, authors, price, quantities etc,...
-
If closing costs of $2,100 are associated with the refinance of a mortgage that would reduce the monthly payment from $1,070 to $1,006 refinance, it would take approximately how many months to cover...
-
Suppose you borrowed $83,000 from a bank. The loan is to be paid back in 4 years. The back proposed the following payment plan: Year 1: $26,753 Year 2: $26,753 Year 3: $26,753 Year 4: $26,753 Using...
-
Capital market instruments include both long-term debt and common stocks, but not commercial paper. a) True b) False
-
If 2 5 9 - k 5 8 = 2 5 8 , what is the value of k?
-
Havaci SpA reports pretax financial income of 80,000 for 2022. The following items cause taxable income to be different than pretax financial income. 1. Depreciation on the tax return is greater than...
-
A fire destroys all of the merchandise of Assante Company on February 10, 2022. The following is information compiled up to the date of the fire. Inventory, January 1, 2022 ............... $ 400,000...
-
Dos Passos SA sells televisions at an average price of R$900 and also offers to each customer a separate 3-year warranty contract for R$90 that requires the company to perform periodic services and...
-
Trudeau's net cash flow from financing activities for 2020 was a. net cash used of \(\$ 25,000\). b. net cash used of \(\$ 20,000\). c. net cash provided of \(\$ 10,000\). d. net cash used of \(\$...
-
Sales totalled \(\$ 800,000\), accounts receivable increased by \(\$ 40,000\), and accounts payable decreased by \(\$ 35,000\). How much cash did this company collect from customers? a. \(\$...
-
Income Tax Payable was \(\$ 5,000\) at the end of the year and \(\$ 2,800\) at the beginning. Income tax expense for the year totalled \(\$ 59,100\). What amount of cash did this company pay for...
Study smarter with the SolutionInn App