View the step-by-step solution to:

Case Study 11-1 Medieval Adventures Questions 1.

Case Study 11-1 Medieval Adventures

Questions

1. Prepare monthly income statements, balance sheets, and cash budgets based on sales increases of 500 units per month and 30-day advanced production for January through September.

See attached income statements, balance sheets and cash budgets.

When will the company need extra funds? How much will be needed? When can a short-term loan to cover the need be repaid?

The company needs extra funds in April to keep from going into a negative bank balance by the end of April. If nothing changes the ending bank balance for April will be -$2500. A short term loan of $2500 will allow the company to continue operating through April. Unfortunately if nothing changes, they will need another short term loan of $25000 to operate through May, $37500 to operate through June, $40000 to operate through July, and $32500 to operate through August. If the business plan is not changed or customers made to pay within

Is this Essay helpful? Join OPPapers to read more and access more than 470,000 just like it!
get better grades
the net 30 terms, a short term loan cannot be repaid with the current sales and production schedule.

2. How is it possible that a company starts with $250,000 in capital and has profitable sales for a period of six months and still ends up with a zero bank balance? Why did Medieval Adventures need money in April? How could this need have been avoided?

The company runs out of cash because the aggressive growth schedule cannot be sustained while the customers are allowed to pay invoiced 30 days late. Medieval Adventures needs money in April because the cost to produce the June inventory. Aaron Reinholz stresses the importance of developing good sales channel relationships; therefore he wants prompt deliveries and schedule production 30days before forecasted sales. He needs to hold his customers to this high standard of prompt delivery to stay within the established payment terms of Net 30.
3. From your calculations and financial statements for question 1, derive cash flow...

This question was asked on Jan 29, 2013.

Recently Asked Questions

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors and customizable flashcards—available anywhere, anytime.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access or to earn money with our Marketplace.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question
  • -

    Flashcards

    Browse existing sets or create your own using our digital flashcard system. A simple yet effective studying tool to help you earn the grade that you want!

    Browse Flashcards