The beginning cash balance is $16,500. Sales are forecasted at $820,000 of which 80% will be on account. Seventy percent of credit sales are expected to be collected in the year of sale. Cashexpenditures for the year are forecasted at $472,000. Accounts Receivable from previous accounting periods totaling $11,800 will be collected in the current year. The company is required tomake a $16,500 loan payment and an annual interest payment on the last day of every year. The loan balance as of the beginning of the year is $90,000, and the annual interest rate is 9%.Compute the excess of available cash over cash disbursements.Excess of available cash over cash disbursements$

Detailed explanation: Cash Receipts and Payments : Cash Balance beginning of year $ 16,500Add :…

Answered: The beginning cash balance is $16,500.…

EBK CONTEMPORARY FINANCIAL MANAGEMENT

14th Edition

ISBN:9781337514835

Author:MOYER

Publisher:MOYER

Chapter3: Evaluation Of Financial Performance

Section: Chapter Questions

Problem 3P

See similar textbooks

Similar questions

Gear Up Co. pays 65% of its purchases in the month of purchase, 30% in the month after the purchase, and 5% in the second month following the purchase. What are the cash payments if it made the following purchases in 2018?
Brandeis, Inc has a 45-day accounts payable period. The firm has expected quarterly sales of $2,400, $2,800, $3,600, and $4,200, respectively, for the next calendar year. The cost of goods sold for a quarter is equal to 70% of the next quarter sales. The firm has a beginning payables balance of $1,200 as of quarter one. What is the amount of the projected cash disbursements for accounts payable for quarter 3 of the next year? Each quarter has 90 days. Multiple Choice $3,900 $2,730 $2,240 $2,870 $3,060
If projected net cash flow for November is ($10,000); beginning cash balance is $4,000; minimum cash balance is $3,000; beginning loan balance is $8,000, what will be the cumulative loan balance and the ending cash balance at the end of November?
A loan of $30,000 is to be financed over a period of 24 months. The agency quotes a nominal interest rate of 9% for the first 12 months and a nominal interest rate of 12% for any remaining unpaid balance after 12 months with both rates compounded monthly. At these rates, what equal end-of-the-month payment for 24 months would be required in order to repay the loan? (Choose the closest answer)
An investment producing cash flows in the amount of $1,200 per month is undertaken for a period of 28 months. The investor pays $24,000 for the investment and the contract stipulates that investment returns must be reported on a basis equivalent with annual compounding. Given that theinvestment is sold after 28 months, what would be the equivalent annual compound rate of interest reported to the investor? What would be the annual rate compounded monthly for this investment?
A debt of ₱75,000 was paid for as follows: ₱15,000 at the end of 18 months, ₱25000 at the end of 24 months, ₱30,000 at the end of 36 months, and a final payment of M at the end of 48 months. The rate of interest was 2% compounded semi-annually.a. Pick a focal date and draw a detailed cash-flow diagram. It is recommended to draw it as big as the width of a letter-sized (whole sheet) paper. b. Declare the focal date.c. Write the equation of value (a) using the symbolic factors, and (b) as a mathematical form (expression).
To provide for the automation of a production process in six years, Invista is starting a sinking fund to accumulate $800,000 by the end of the six years. Round the sinking fund payments and the periodic interest earnings to the nearest dollar. If the sinking fund earns 6.4% compounded monthly, what month end payments should be made to the fund? In what month will the fund pass the halfway point?
A total of $50,000 is borrowed and repaid with 60 monthly payments, with the first payment occurring one month after receipt of the $50,000. The stated interest rate is 6% compounded quarterly. What monthly payment is required?
Olfert Inc. is repaying a loan of $52500.00 by making payments of $4700.00 at the end of every six months. If interest is 7.5% compounded semi-annually, the outstanding balance after the first, second, third payment will be respectively: O 49268.75, 47565.08 and 43995.14 O 49768.75, 45015.08 and 42105.48 49768.75, 46935.08 and 43995.14 O48425.12, 45238.21 and 42355.23 Mrs. Robinson made
A loan of $15,000 requires monthly payments of $477 over a 36-month period of time. These payments include both principal and interest. Solve, (a) What is the nominal interest rate (APR) for this loan? (b) What is the effective interest rate per year? (c) Determine the amount of unpaid loan principal after 20 months.
A loan of $12,000 is repaid by payments of $571 at the end of every three months. Interest is 9% compounded quarterly (a) How many payments are required to repay the debt? (b) What is the size of the final payment?
Bank JPX is offering personal loans of $35,000 to be repaid over 6 years with payments of $625 per month. The first loan payment occurs one month after borrowing the $35,000. What effective annual rate (EAR) are they charging on this loan?

SEE MORE QUESTIONS

Recommended textbooks for you

EBK CONTEMPORARY FINANCIAL MANAGEMENT

Finance

ISBN:

9781337514835

Author:

MOYER

Publisher:

CENGAGE LEARNING - CONSIGNMENT

Principles of Accounting Volume 2

Accounting

ISBN:

9781947172609

Author:

OpenStax

Publisher:

OpenStax College

Principles of Accounting Volume 1

Accounting

ISBN:

9781947172685

Author:

OpenStax

Publisher:

OpenStax College

EBK CONTEMPORARY FINANCIAL MANAGEMENT

Finance

ISBN:

9781337514835

Author:

MOYER

Publisher:

CENGAGE LEARNING - CONSIGNMENT

Principles of Accounting Volume 2

Accounting

ISBN:

9781947172609

Author:

OpenStax

Publisher:

OpenStax College

Principles of Accounting Volume 1

Accounting

ISBN:

9781947172685

Author:

OpenStax

Publisher:

OpenStax College

Intermediate Financial Management (MindTap Course…

Finance

ISBN:

9781337395083

Author:

Eugene F. Brigham, Phillip R. Daves

Publisher:

Cengage Learning

SEE MORE TEXTBOOKS