Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

3. Camp and Fevurly Financial Planning have forecasted revenues for the first six months of 2021, as shown in the following table. Month Revenue

image text in transcribedimage text in transcribed

3. Camp and Fevurly Financial Planning have forecasted revenues for the first six months of 2021, as shown in the following table. Month Revenue Month Revenue November 2020 $44,160 March 34,224 December 41,400 April 40,553 January 2021 32,200 May 40,755 February 32,788 June 41,400 The firm collects 70% of its sales immediately, 29% one month after the sale, and 1% are written off as bad debts two months after the sale. The firm assumes that wages and benefits paid to clerical personnel will be $9,125 per month while commissions to sales associates average 25% of collectable sales. Each of the two partners is paid $5,000 per month or 20% of net sales, whichever is greater. Com- missions and partner salaries are paid one month after the revenue is earned. Rent expense for their office space is $4,750 per month, and lease expense for office equipment is $920. Utilities average $288 per month, except in May and June when they average only $173. The ending cash balance in December 2020 was $12,000. 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 $1,000 and ignore interest charges on short-term debt. (Hint: Look up the ROUNDUP function in the online help.)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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 Analysis With Microsoft Excel

Authors: Timothy R. Mayes

9th Edition

0357442059, 9780357442050

More Books

Students also viewed these Finance questions

Question

What is the driving force for mountain building in the Andes?

Answered: 1 week ago

Question

Is any version better than the other models?

Answered: 1 week ago

Question

What is cultural tourism and why is it growing?

Answered: 1 week ago