Question
The CEO would like you to determine whether the company is projected to have enough cash to purchase additional equipment and to expand its operations
The CEO would like you to determine whether the company is projected to have enough cash to purchase additional equipment and to expand its operations to begin paying dividends each quarter. The CEOs top priority is to purchase equipment with a cost of $5,450,000 in the fourth quarter of 2023. Secondly, the CEO has been taking a salary from the company, but the other 9 shareholders havent received any return on their initial investment in the company yet and would like to achieve a regular 10% annual rate of return on their initial stock investment of $26,234,500, although they realize that it may take a few more years to achieve that level. Please fill in the yellow cells regarding equipment purchases and dividends for each quarter, then write a paragraph or two justifying your decision.
CASH BUDGET Cash Collections: Collections in quarter of sale Collections in quarter following sale Total Cash Receipts Cash Disbursements: Variable Supplies - Payments in quarter of purchase Payments in quarter following purchase Variable Labor Costs Overhead Costs Selling and Administrative Costs Total Cash Disbursements Net Operating Cash Flows $ Net Cash Available Minimum cash balance Cash Available for Discretionary Uses Discretionary Uses of Cash Equipment Purchases Dividends Leave Financing section empty: Financing: (should not be required) Borrowing Repayment Interest Total Financing Cash Increase (Decrease) Total Cash Available After Dicretionary Cash Uses Interest Earned on Cash Ending Cash Balance \begin{tabular}{|c|} \hline First \\ \hline Quarter \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|} \hline$ & 17,536,881 & $ & 11,839,969 \\ \hline$ & 4,050,000 & $ & 3,691,975 \\ \hline$ & 21,586,881 & $ & 15,531,944 \\ \hline \end{tabular} Third Quarter Fourth Quarter (s \begin{tabular}{|c|c|c|c|} \hline$ & 5,863,725.00 & $ & 3,958,875.00 \\ \hline$ & 1,500,000 & $ & 1,034,775.00 \\ \hline$ & 8,968,050 & $ & 6,054,750 \\ \hline \end{tabular} \begin{tabular}{r|} \hline 3,557,250.00 \\ \hline 698,625.00 \\ \hline 5,440,500 \\ \hline 1,298,750 \\ \hline \end{tabular} 1,338,125 \begin{tabular}{|lrr|rr|} \hline$ & 940,113 & $ & 693,188 \\ \hline$ & 18,796,763 & $ & 13,079,713 \\ \hline \end{tabular} \begin{tabular}{|rr|rrrr|rr|r|r|} \hline$ & 2,790,119 & $ & 2,452,231 & $ & 1,495,188 & $ & 1,634,938 & $ & 8,372,475 \\ \hline$ & 6,150,000 & $ & 8,690,119 & $ & 10,892,350 & $ & 12,137,538 & $ & 6,150,000 \\ \hline$ & 8,940,119 & $ & 11,142,350 & $ & 12,387,538 & $ & 13,772,475 & $ & 14,522,475 \\ \hline$ & 250,000 & $ & 250,000 & $ & 250,000 & $ & 250,000 & $ & 250,000 \\ \hline$ & 8,690,119 & $ & 10,892,350 & $ & 12,137,538 & $ & 13,522,475 & $ & 14,272,475 \\ \hline \end{tabular} Grayed cells are not usedStep 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