Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

PART 2 (40%): Kayla just launched a business named Kayla's Kayaks. The bank has asked her for a Cash Budget for the first quarter, but

image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
PART 2 (40%): Kayla just launched a business named Kayla's Kayaks. The bank has asked her for a Cash Budget for the first quarter, but she has no idea how to do this. Knowing that you are currently rocking it in your Finance class, Kayla has asked for your help in creating this Cash Budget. She gave you the following information based on actual and forecasted sales. November Sales: $10,000 December Sales: $15,000 January Sales: $16,000 February Sales: $20,000 March Sales: $25,000 April Sales: $30,000 Kayla's sales are 50% cash and 50% on credit. Of the credit sales, half is collected during the month after the sale and the remainder is collected two months after the sale. Kayla's materials (kayaks and kayak gear) cost 40% of sales. She purchases enough materials each month to cover next month's sales. Her materials are paid for in the month after they are purchased. Kayla's labor costs are 10% of sales, her overhead costs are $2,000 per month, and her selling and administrative expenses are 5% of sales. These are all paid during the month of the sale. She will need to pay taxes of $6,000 in January and she needs to make a capital purchase of $10,000 in March. Her January starting cash balance is $25,000, which is also her desired minimum cash balance. She has a line of credit at the bank and can borrow from it as necessary to meet her minimum cash balance goal. Ignore interest. Create a first-quarter cash budget for Kayla's Kayaks. This budget should cover January, February, and March. Make an Excel sheet, explain and demonstrate everything step by step

Step by Step Solution

There are 3 Steps involved in it

Step: 1

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

Financial Management Theory And Practice

Authors: Eugene F. Brigham, Michael C. Ehrhardt

10th Edition

0030329922, 9780030329920

More Books

Students also viewed these Finance questions

Question

What are the skills of management ?

Answered: 1 week ago