Answered step by step
Verified Expert Solution
Question
1 Approved Answer
4 . Camp and Fevurly Financial Planning have forecasted revenues for the first six months of 2 0 2 1 , as shown in the
Camp and Fevurly Financial Planning have forecasted revenues for the first six months of as shown in the following table. Month Revenue Month Revenue November $ March December April January May February June The firm collects of its sales immediately, one month after the sale, and are written off as bad debts two months after the sale. The firm assumes that wages and benefits paid to clerical personnel will be $ per month while commissions to sales associates average of collectable sales. Each of the two partners is paid $ per month or of net sales, whichever is greater. Commissions and partner salaries are paid one month after the revenue is earned. Rent expense for their office space is $ per month, and lease expense for office equipment is $ Utilities average $ per month, except in May and June when they average only $ The ending cash balance in December was $ A Create a cash budget for January to June and determine the firms ending cash balance in each month assuming that the partners wish to maintain a minimum cash balance of $ B Camp and Fevurly are thinking of obtaining a line of credit from their bank. Based on their forecast for the first six months of the year, what is the minimum amount that would be necessary? Round your answer to the next highest $ and ignore interest charges on shortterm debt. Hint: Look up the rounDup function in the online help. C Create three scenarios best case, base case, and worst case assuming that revenues are better than expected, exactly as expected, or worse than expected. What is the maximum that the firm would need to borrow to maintain its minimum cash balance in all three cases? Use the Scenario Manager, and create a summary of your results. Would this change your answer in part b
Camp and Fevurly Financial Planning have forecasted revenues for the first six months of as shown in the following table.
Month Revenue Month Revenue
November $ March
December April
January May
February June
The firm collects of its sales immediately, one month after the sale, and are written off as bad debts two months after the sale. The firm assumes that wages and benefits paid to clerical personnel will be $ per month while commissions to sales associates average of collectable sales. Each of the two partners is paid $ per month or of net sales, whichever is greater. Commissions and partner salaries are paid one month after the revenue is earned. Rent expense for their office space is $ per month, and lease expense for office equipment is $ Utilities average $ per month, except in May and June when they average only $ The ending cash balance in December was $
A Create a cash budget for January to June and determine the firms ending cash balance in each month assuming that the partners wish to maintain a minimum cash balance of $
B Camp and Fevurly are thinking of obtaining a line of credit from their bank. Based on their forecast for the first six months of the year, what is the minimum amount that would be necessary? Round your answer to the next highest $ and ignore interest charges on shortterm debt. Hint: Look up the rounDup function in the online help.
C Create three scenarios best case, base case, and worst case assuming that revenues are better than expected, exactly as expected, or worse than expected. What is the maximum that the firm would need to borrow to maintain its minimum cash balance in all three cases? Use the Scenario Manager, and create a summary of your results. Would this change your answer in part b
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