Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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.

image text in transcribed

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 used

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

More Books

Students also viewed these Accounting questions

Question

c. What were you expected to do when you grew up?

Answered: 1 week ago

Question

4. Describe how cultural values influence communication.

Answered: 1 week ago

Question

3. Identify and describe nine cultural value orientations.

Answered: 1 week ago