1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
Anvisha [2.4K]
3 years ago
10

Foyert Corp. requires a minimum $30,000 cash balance. Loans taken to meet this requirement cost 1% interest per month (paid mont

hly). Any excess cash is used to repay loans at month-end. The cash balance on October 1 is $30,000, and the company has an outstanding loan of $10,000. Forecasted cash receipts (other than for loans received) and forecasted cash payments (other than for loan or interest payments) follow.
October November December
Cash receipts $ 110,000 $ 80,000 $ 100,000
Cash payments 120,000 75,000 80,000
Prepare a cash budget for October, November, and December. (Negative balances and Loan repayment amounts (if any) should be indicated with minus sign. Round your final answers to the nearest whole dollar.)
Business
1 answer:
igor_vitrenko [27]3 years ago
8 0

Answer:

From the attached excel file, we have:

a. Ending Cash Balance:

October = $30,000

November = $30,000

December = $34,546

b. Loan Balance End of Month:

October = $20,100

November = $15,301

December = $0

Explanation:

Note: See the attached excel file for the cash budget for October, November, and December.

In the attached excel file, the following calculations are made:

October additional loan = Minimum required cash balance - October Preliminary cash balance = $30,000 - $19,900 = $10,100

November Loan Repayment = November Preliminary cash balance - Minimum required cash balance = $34,799 = $30,000 = $4,799

Download xlsx
You might be interested in
Prepaid Advertising Debit Balance $1100
alukav5142 [94]

Answer:

Debit   Advertising expense  $916.67

Credit  Prepaid Advertising    $916.67

Being entries to recognize advertising expense incurred for 5 months.

Explanation:

When an amount is paid in advance, the entries posted are

Debit Prepaid Advertising  

Credit Cash account (with the amount prepaid)

As the expense is incurred, entries required would be

Debit Advertising expense

Credit  Prepaid Advertising  (with the amount incurred)

Expense incurred in 5 months

= 5/6 × $1100

= $916.67

Hence the entries required will be

Debit   Advertising expense  $916.67

Credit  Prepaid Advertising    $916.67

Being entries to recognize advertising expense incurred for 5 months.

5 0
4 years ago
When forecasting fixed asset​ requirements, the projected fixed asset balance will
iren2701 [21]

Answer:

C. not increase proportionally with sales if the existing level of fixed assets is sufficient to support current sales.

Explanation:

The total assets comprises of current assets, fixed assets and the intangible assets .

The current assets includes cash, stock, account receivable, etc

Fixed assets include plant & machinery, land, equipment, furniture & fittings, etc.

And, the intangible assets include patents, copyrights, goodwill, etc.  

If the existing level of the fixed asset is enough to support the current assets so the projected fixed assets balance would not be increased proportionally with the increase in sales

4 0
3 years ago
According to the trust-based relationship selling process framework, "discovering prospect's needs" is a part of which component
Kryger [21]
<span>
According to the trust-based relationship selling process framework, "discovering prospect's needs" is a part of the  i</span>nitiating customer relationship as a component of the framework. 
<span> The initiation of customer relation is involved in the CRM (Customer Relationship Management), an approach that includes the interaction with current and potential </span>customers<span>. </span>
8 0
3 years ago
The invention of what product skyrocketed the popularity of pecan pie?
Nezavi [6.7K]

Answer:

Karo Syrup

Explanation:

Karo Syrup is delicious on Pecan Pie

3 0
3 years ago
Does owning new clothes, shoes and the latest electronics mean that someone is rich? Explain.
mafiozo [28]

Answer:

No they just want to look rich

7 0
3 years ago
Other questions:
  • Name two features of capitalism
    12·1 answer
  • A fixed expense is a _____.
    5·1 answer
  • Which of the statements below is​ FALSE? A. Preferred stock does not have a maturity date. B. Preferred​ shareholders' dividend
    8·1 answer
  • Analyst 1 suggested that the demand curve for newspapers in Baltimore might have shifted to the right because people were becomi
    8·1 answer
  • Look at the scenario Linear Production Possibility Frontier. What is the maximum number of pairs of socks Largetown can produce?
    5·1 answer
  • What are some of the difficulties in measuring innate capacity and in measuring developed performance?
    13·1 answer
  • On January 22, Zentric Corporation issued for cash 160,000 shares of no-par common stock at $8. On February 14, Zentric issued a
    9·1 answer
  • you are the manager of a hamburger joint with a marginal cost of $6.00 per hamburger. The hamburger joint is a local monopoly ne
    14·1 answer
  • A process that produces computer chips has a mean of .04 defective chip and a standard deviation of .003 chip. The allowable var
    9·1 answer
  • A company is considering three alternative machines. The company uses a MARR of 5%. Assuming that Alternative B and C are replac
    11·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!