Prepare a Cash Budget for the six months ending June

Assignment Help Financial Accounting
Reference no: EM132905879

Problem - On January 1, 2020, Dr. Badal intends to establish his own medical facility, Badal Medical Centre, in Browns Town, St. Ann. She intends to finance the start up with a bank loan of $2,200,000 and so assumes that the loan will be disbursed during the first week of January 2020. The loan is to be repaid with monthly interest payments of $250,000 and principal payments of $200,000 at the end of each quarter.

She will outfit the facility with equipment that will be purchased over a three-year period in anticipation of opening his facility. However, she projects that she needs to buy additional equipment to ensure that she provides cutting edge service to her patients. Equipment costing $400,000 will be purchased in February, $500,000 in April and $400,000 in June.

The table below reveals the projected monthly billing revenue for services:

January 4 400 000

February 4 400 000

March 4 500 000

April 4 500 000

May 5 000 000

June 5 000 00

Badal has advised of the following:

Patients will be required to pay 20% of the billing fee upfront. 75% of total monthly billing will be paid by the Patients' insurance providers the following month. 5% of total monthly billing is deemed uncollectible.

The monthly cost of supplies is equivalent to 40% of the billings' revenue. Half of this cost is paid in the month of purchase. The balance is to be paid in the following month.

Monthly salaries are estimated to be $900,000 plus 10% of total billings revenue.

Other Operating expenses are estimated to be 11% of billings revenue each month.

Required - Prepare a Cash Budget for the six months ending June 2020 for Badal Medical Services (Show all workings).

Reference no: EM132905879

Questions Cloud

Financial management online class : 1) What questions will you carry forward, either because of inherent value to continue to inform , or just because they remain perplexing?
Assignment on it hardware-software ltd : New business breaks turnover targets supported by RBS Fledgling Prestwich-based IT business is on course to record an £8m turnover in its first full year of tra
Gross domestic product : Explain why a large GDP is a good thing for the economy and society. Tell your audience what a large GDP should mean to an economy, a society.
Write down the management decision problem : A national clothes retail chain is facing the problem of not getting enough repeat customers. They undertook the help of a research firm to get to the solution
Prepare a Cash Budget for the six months ending June : Patients will be required to pay 20% of the billing fee upfront. Prepare Cash Budget for six months ending June 2020 for Badal Medical Services
Concept of developing an economy : Develop an executive summary on a project proposal focussed on the concept of developing an economy that works for women.
Demand and supply in how global markets work : This discussion board addresses the interaction among price, demand, and supply in how global markets work.
Calculate selling price of each battery : Calculate selling price of each battery. Last year, a battery manufacturing company in Toronto incurred a loss of $588,000.00 by producing.
Calculate c investment : Three friends, A, B, and C, start.Calculate C's investment. A invested $11,700, and all three of them agree to share profits in the ratio of their investments.

Reviews

Write a Review

Financial Accounting Questions & Answers

  Financial statement analysis and preparation

Financial Statement Analysis and Preparation

  Shareholder of a company

Describe the ways that a person can become a shareholder of a company. Why Wal-Mart would split its stock?

  Financial and accounting principles

An understanding of financial and accounting principles can be a valuable tool for managers. While not all managers will find themselves calculating financial ratios or preparing annual financial data.

  Prepare a statement of cash flow using the direct method

Prepare a Statement of Cash Flow using the Direct Method and Prepare the Operations section of the Statement of Cash Flow using the Indirect Method.

  Financial accounting assignment

This assignment has one case study and two question apart from case study. Questions related to document Liquidation question and Company financial statements question - Torquay Limited

  Prepare general journal entries for goela

Prepare general journal entries for Goela Ltd

  Principles of financial accounting

Prepare the journal entry to record the acquisition of the assets.

  Prepare general journal entries to record the transactions

Prepare general journal entries to record the transactions, assuming use of the periodic inventory system

  Global reporting initiative

Compare the view espoused by the economist Milton Friedman about the social responsibilities of business with the views express by Stigler.

  Explain the iasb conceptual frameworks

Explain the IASB Conceptual Framework's perspective of users and their decisions.

  Determine the company''s financial statements

T he focus of the report is to determine the extent to which you are comfortable relying on the financial statements as presented by management .

  Computation of free cash flow

Computation of Free Cash Flow

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