Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

$81,000 are due in Aprill. The firm also intends to make a s23,000 cash purchase of fixed assets in December. a. Assuming that the firm

image text in transcribedimage text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

\$81,000 are due in Aprill. The firm also intends to make a s23,000 cash purchase of fixed assets in December. a. Assuming that the firm has a cash balance of $21,000 at the beginning of November, determine the end-of-month cash balances for each month, November through April. b. Assuming that the firm wishes to maintain a $15,000 minimum cash balance, determine the required total financing or excess cash balance for each month, November through April. c. If the firm were requesting a line of credit to cover needed financing for the period November to April, how large would this line have to be? Explain your answer. a. Assuming that the firm has a cash balance of $21,000 at the beginning of November, determine the end-of-month cash balances for each month, November through April. Complete the November cash budget for Xenocore, Inc. below: (Round to the nearest dollar.) arest dollar.) Add: Beginning cash Ending cash Complete the January cash budget for Xenocore, Inc. below. (Round to the nearest dollar.) Payments Lag 1 month $ Lag 2 month $ Salaries and wages s Rent $ Interest payments s Principal payments $ Dividends s. Taxes 5 Purchases of fixed assets Total cash disbursements Net cash flow \begin{tabular}{l} $ \\ \hline$ \end{tabular} t dollar. fomplete the March cash budget for Xenocore, Inc. below: (Round to the nearest dollar.) C Ilar.) b. Assuming that the firm wishes to maintain a $15,000 minimum cash balance, determine the required total financing or excess cash balance for each month, November through April. Complete the table below: (Round to the nearest dollar.) c. The line of credit should be at least $ to cover the maximum borrowing needs for the month of (Round to the nearest dollar. Type the full name of the month, e.g.. February.) \$81,000 are due in Aprill. The firm also intends to make a s23,000 cash purchase of fixed assets in December. a. Assuming that the firm has a cash balance of $21,000 at the beginning of November, determine the end-of-month cash balances for each month, November through April. b. Assuming that the firm wishes to maintain a $15,000 minimum cash balance, determine the required total financing or excess cash balance for each month, November through April. c. If the firm were requesting a line of credit to cover needed financing for the period November to April, how large would this line have to be? Explain your answer. a. Assuming that the firm has a cash balance of $21,000 at the beginning of November, determine the end-of-month cash balances for each month, November through April. Complete the November cash budget for Xenocore, Inc. below: (Round to the nearest dollar.) arest dollar.) Add: Beginning cash Ending cash Complete the January cash budget for Xenocore, Inc. below. (Round to the nearest dollar.) Payments Lag 1 month $ Lag 2 month $ Salaries and wages s Rent $ Interest payments s Principal payments $ Dividends s. Taxes 5 Purchases of fixed assets Total cash disbursements Net cash flow \begin{tabular}{l} $ \\ \hline$ \end{tabular} t dollar. fomplete the March cash budget for Xenocore, Inc. below: (Round to the nearest dollar.) C Ilar.) b. Assuming that the firm wishes to maintain a $15,000 minimum cash balance, determine the required total financing or excess cash balance for each month, November through April. Complete the table below: (Round to the nearest dollar.) c. The line of credit should be at least $ to cover the maximum borrowing needs for the month of (Round to the nearest dollar. Type the full name of the month, e.g.. February.)

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

Tracking Your Trek Looking Backward To Determine Your Forward

Authors: Erica Pauly

1st Edition

979-8839157330

More Books

Students also viewed these Accounting questions