Happy valley rehab facility revenues

Assignment Help Financial Management

Reference no: EM131987277

Happy Valley Rehab Facility provided the financial information below in Exhibit 5-17. Calculate the ending cash balance for January 30, 20X1.[x] Exhibit 5-17 Happy Valley Rehab Facility Revenues: Estimated Patient Patient Revenues, 20X0 Patient Revenues, 20X0 Revenues, 20X1 July $4,200,000 October $4,500,000 January $4,600,000 August $4,400,000 November $4,550,000 February $4,500,000 September $4,500,000 December $4,600,000 March $4,500,000 Receipt of Payment Other Revenues, 20X1 for Patient Services / Revenues January $900,000 Current month of service 45% February $910,000 1st month of prior service 25% March $950,000 2nd month of prior service 10% 3-6 months of prior service 5% Expenses a: Estimated Supplies Other Estimated Expenses, 20X1a Supplies Purchases, 20X0 Purchases, 20X1 Nursing Admin. Other October $900,000 January $1,000,000 January $2,000,000 $100,000 $700,000 November $950,000 February $1,025,000 February $2,100,000 $100,000 $675,000 December $1,000,000 March $1,050,000 March $2,200,000 $100,000 $650,000 April $1,075,000 April $2,300,000 $100,000 $525,000 Timing of Cash Payment for Supplies Purchases Ending Cash Balances 0% Month purchased December, 20X0 $700,000 60% +1 Month b 50% 30% +2 Months 10% +3 Months a All estimated expenses are cash outflows for the given month. b The ending balance for each month as a percentage of the estimated cash outflows for the next month. Happy Valley Rehab Facility provided the financial information below in Exhibit 5-17. Calculate the ending cash balance for January 30, 20X1.[x] Exhibit 5-17 Happy Valley Rehab Facility Revenues: Estimated Patient Patient Revenues, 20X0 Patient Revenues, 20X0 Revenues, 20X1 July $4,200,000 October $4,500,000 January $4,600,000 August $4,400,000 November $4,550,000 February $4,500,000 September $4,500,000 December $4,600,000 March $4,500,000 Receipt of Payment Other Revenues, 20X1 for Patient Services / Revenues January $900,000 Current month of service 45% February $910,000 1st month of prior service 25% March $950,000 2nd month of prior service 10% 3-6 months of prior service 5% Expenses a: Estimated Supplies Other Estimated Expenses, 20X1a Supplies Purchases, 20X0 Purchases, 20X1 Nursing Admin. Other October $900,000 January $1,000,000 January $2,000,000 $100,000 $700,000 November $950,000 February $1,025,000 February $2,100,000 $100,000 $675,000 December $1,000,000 March $1,050,000 March $2,200,000 $100,000 $650,000 April $1,075,000 April $2,300,000 $100,000 $525,000 Timing of Cash Payment for Supplies Purchases Ending Cash Balances 0% Month purchased December, 20X0 $700,000 60% +1 Month b 50% 30% +2 Months 10% +3 Months a All estimated expenses are cash outflows for the given month. b The ending balance for each month as a percentage of the estimated cash outflows for the next month. Happy Valley Rehab Facility provided the financial information below in Exhibit 5-17. Calculate the ending cash balance for January 30, 20X1.[x] Exhibit 5-17 Happy Valley Rehab Facility Revenues: Estimated Patient Patient Revenues, 20X0 Patient Revenues, 20X0 Revenues, 20X1 July $4,200,000 October $4,500,000 January $4,600,000 August $4,400,000 November $4,550,000 February $4,500,000 September $4,500,000 December $4,600,000 March $4,500,000 Receipt of Payment Other Revenues, 20X1 for Patient Services / Revenues January $900,000 Current month of service 45% February $910,000 1st month of prior service 25% March $950,000 2nd month of prior service 10% 3-6 months of prior service 5% Expenses a: Estimated Supplies Other Estimated Expenses, 20X1a Supplies Purchases, 20X0 Purchases, 20X1 Nursing Admin. Other October $900,000 January $1,000,000 January $2,000,000 $100,000 $700,000 November $950,000 February $1,025,000 February $2,100,000 $100,000 $675,000 December $1,000,000 March $1,050,000 March $2,200,000 $100,000 $650,000 April $1,075,000 April $2,300,000 $100,000 $525,000 Timing of Cash Payment for Supplies Purchases Ending Cash Balances 0% Month purchased December, 20X0 $700,000 60% +1 Month b 50% 30% +2 Months 10% +3 Months a All estimated expenses are cash outflows for the given month. b The ending balance for each month as a percentage of the estimated cash outflows for the next month.

Reference no: EM131987277

Questions Cloud

What is the tea party : Do you think the rise of the Tea Party has been beneficial for the Republican Party? Why or why not?

What was the most important event of world war ii : What was the most important event of World War II, in your opinion? Why did you choese this one? Be sure to support your opinion with historical facts.

Benefit and suffer from illegal immigration : In what ways do the United States both benefit and suffer from illegal immigration? Imagine you were hired as a consultant by the Federal Government

How the provisions of the usa patriot act combat terrorism : Describe how the provisions of the USA PATRIOT Act grants law enforcement and intelligence officials special powers to combat terrorism.

Happy valley rehab facility revenues : Calculate the ending cash balance for January 30, 20X1.[x] Exhibit 5-17 Happy Valley Rehab Facility Revenues:

What innovation invention or gadget would you create : If you had the resources and the time, what innovation, invention (technology) or gadget would you create? Why?

The trade-off between security and civil rights : Assess this Act on the trade-off between security and civil rights. Has this Act been effective, equal, and ethical?

Company evaluated project as low-risk project : Chovita Sports Company evaluated a project as a low-risk project. If Chovita expects 12% return on average risk projects,

True of capital structures around the world : Which of the following statements is true of capital structures around the world??

User Account

All Pages