Answered step by step
Verified Expert Solution
Question
1 Approved Answer
PART A: Part B Part c Complete this question by entering your answers in the tabs below. The owners want to ensure that they have
PART A:
Part B
Part c
Complete this question by entering your answers in the tabs below. The owners want to ensure that they have cash on hand at the end of the year equal to the current accounts payable balance n December 31 . Will the store meet that requirement? Required information [The following information applies to the questions displayed below.] Owen Surf Sports is an idea of two budding entrepreneurs. Their plan is to sell kiteboards from a store in the local town. Between them, they invest $40,000 in capital and are in the process of applying for a bank loan, also for $40,000. The loan would be repaid in four years. The owners will also pay the bank annual interest at a rate of 6 percent. The owners are working on a business plan that the bank has requested. The store would sell only two models of kites initially, the X1 and the X2. Data on the kites are given as follows: Additional information on the planned operations for the year includes the following: 1. Equipment costing $53,000 will be purchased for cash when the store opens. The equipment will be depreciated over five years using straight-line depreciation. 2. The owners expect sales to occur uniformly over the year. Sales will be both for cash (60 percent) and on account (40 percent). Sales on account are assumed to be collected in two months. 3. The owners will maintain inventory equal to one-half of a month's sales. All kites will be purchased from the manufacturer on credit with payment made one month after purchase. 4. Annual cash selling, general, and administrative expenses are $50,000 fixed plus 10 percent of revenues. 5. The applicable income tax rate is 20 percent. a. Prepare a cash budget for the year. b. The owners want to ensure that they have cash on hand at the end of the year equal to the current accounts payable balance on December 31. Will the store meet that requirement? c. Consider only the assumption about the percentage of sales that will be made on account (currently 40 percent). What assumption about this percentage would exactly achieve the goal set by the owners in requirement (b) ? Complete this question by entering your answers in the tabs below. Consider only the assumption about the percentage of sales that will be made on account (currently 40 percent). What assumption about this percentage would exactly achieve the goal set by the owners in requirement (b) ? Note: Do not round intermediate calculations. Round your answer to 1 decimal place. \begin{tabular}{|c|c|c|} \hline \multicolumn{3}{|l|}{ Owen Surf Sports } \\ \hline \multicolumn{3}{|l|}{ Cash Budget } \\ \hline \multicolumn{3}{|l|}{ For the Year Ended December 31} \\ \hline Cash balance beginning of the year & & 02 \\ \hline \multicolumn{3}{|l|}{ Receipts } \\ \hline Contribution from owners & 40,000 & \\ \hline Proceeds from loan & 40,000 & \\ \hline Cash sales & 270,000 & \\ \hline Collection on accounts receivables & 360,000 & \\ \hline Total receipts & & 710,000 \\ \hline \multicolumn{3}{|l|}{ Less disbursements } \\ \hline Payments to vendors & & \\ \hline Purchase of equipment & & \\ \hline Selling, general, and administrative expenses (variable) & (3) & \\ \hline Selling, general, and administrative expenses (fixed) & & \\ \hline Interest expense & 3 & \\ \hline Payment of taxes & & \\ \hline Total disbursements & & 0 \\ \hline Net cash flow & & $710,000 \\ \hline \end{tabular}Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started