Answered step by step
Verified Expert Solution
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
\$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
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