Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Jana and Cindy are planning to launch UP-PACK, a business that upcycles disposable masks into high quality packaging material. They think it can be a

image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
Jana and Cindy are planning to launch UP-PACK, a business that upcycles disposable masks into high quality packaging material. They think it can be a viable business but they need your advice; they want to make sure they aren't taking too big of a risk. Use the information below to create a 6 month cash budget. Based on their research of the industry, they plan to provide credit terms to their custemers of 35% payment during the month of sale and 65% payment in the month following sale. Manufacturing supply costs are relatively low since they can get free used disposable masks from health care facilities but there are costs incurred to clean and upcycle the masks. They project their costs of goods sold (COGS) to be 24% of each month's sales. They anticipate having to pay 60% of these costs in the month of purchase and 40% in the month following purchase. Fortunately, Jana's brother has a large empty garage that they can operate in for the first year which saves them from renting space. They are going to contribute to his utility costs as listed in the chart below. Because they are selling to businesses, their marketing budget is largely allocated to personal selling (reflected in payroll costs). Jana and Cindy have $5,500 set aside as their beginning cash balance. Going forward, they do not want their cash balance to go below $3,000. Because they have strong personal credit histories and other sources of household income from their respective partners, they have been approved for a bank line of credit at a rate of 6%. If they need to use this line of credit, they will pay interest in the month following borrowing. Once they have a cash surplus, they will pay down as much of the outstanding line of credit as possible. Because they are selling to businesses, their marketing budget is largely allocated to personal selling (reflected in payroll costs). Jana and Cindy have $5,500 set aside as their beginning cash balance. Going forward, they do not want their cash balance to go below $3,000. Because they have strong personal credit histories and other sources of household income from their respective partners, they have been approved for a bank line of credit at a rate of 6%. If they need to use this line of credit, they will pay interest in the month following borrowing. Once they have a cash surplus, they will pay down as much of the outstanding line of credit as possible. Round all amounts up to the nearest dollar when preparing the cash budget and then answer the multiple choice questions below by entering the correct answer letter into the associated text box. Provide ONLY the letter of the correct answer for each one (not the answer itself, or any punctuation marks) Cash Budget Q1 . Total Receipts for June are: a) $26,000 b) $9,100 c) $13,000 d) $22,100 Cash Budget Q2 Net Purchases for January are: a) $3,000 b) $7,500 c) $5,000 d) $1,800 Cash Budget Q3 Total Purchase Disbursements for March are: a) $3,840 b) $2,304 c) $1,344 d) $3,648 Cash Budget Q4 Line of Credit Interest for May is: a) $676 b) $11,257 c) $56 d) $49 Cash Budget Q5 Financing Required in April is: a) $3,000 b) $1,014 c) $0 d) $606 Cash Budget Q6 Ending Cash Balance in June is: a) $3,000 b) $7,793 c) $4,793 d) $3,751

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

Mergers And Acquisitions A Study Of Financial Performance Motives And Corporate Governance

Authors: Neelam Rani , Surendra Singh Yadav, Pramod Kumar Jain

1st Edition

981102202X,9811022038

More Books

Students also viewed these Finance questions