Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Rhonda runs a six - week summer camp in the North Georgia Mountains ( three weeks in June and three weeks in July ) .

Rhonda runs a six-week summer camp in the North Georgia Mountains (three weeks in June and three weeks in July). Between 20 and 30 campers sign up for the summer, each paying $2,000 for the six-week session. She receives 20% as a down payment in March when the campers book their summer camp and the remainder on arrival at the camp for the summer in June. Rhonda pays her four counselors $3,000 each in August. Rhonda buys the supplies for camp for cash in April, costing $4,000. At the end of June, Rhonda normally has about $2000 of supplies left over and at the end of July, Rhonda had $350 of supplies leftover if there are fewer campers and none left over with more campers enrolled. Utilities, horse feed, food are charged to the camps mastercard and paid at the end of August, totaling $6,000-$7,000, depending on attendance, used evenly in each week of the sessions.Rhonda wants to buy a used bus for fieldtrips, costing $37,000, but the bank requires an accrual basis and cash basis analysis for the summer camp to show she can pay back the loan in two years, even at lower enrollment levels. Please prepare a cash flow and accrual basis profit analysis for a typical summer camp season at low and high enrollment. Using these schedules, explain to Rhonda if she will likely be able to pay back the loan. Rhonda is busy so be brief and get to the point, including a clear schedule to support your points. A starter executive summary memo is provided to give you an idea of what Rhonda needs. The missing parts you complete. Edit and adjust to fit your results and ideas.LOW ENROLLMENTCASH BASIS:MarchAprilJuneJulyAugustSeasonRevenueCounselor salary expenseSupplies expenseUtilities, horses, foodProfitsACCRUAL BASIS:RevenueCounselor salary expenseSupplies expenseUtilities, horses, foodProfitsHIGH ENROLLMENTCASH BASIS:MarchAprilJuneJulyAugustSeasonRevenueCounselor salary expenseSupplies expenseUtilities, horses, foodProfitsACCRUAL BASIS:RevenueCounselor salary expenseSupplies expenseUtilities, horses, foodProfits

Step by Step Solution

There are 3 Steps involved in it

Step: 1

Executive Summary Based on the provided information I have prepared cash flow and accrual basis prof... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Elementary Statistics

Authors: Mario F. Triola

3rd Canadian Edition

032122597X, 978-0321225979

More Books

Students also viewed these Accounting questions

Question

How are writable CDs implemented?

Answered: 1 week ago

Question

3. What steps can you take to manage your ego more effectively?

Answered: 1 week ago