Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Everything in yellow needs to be answered. Some slots are filled, but i do not think I did it right so please DISREGARD those numbers.
Everything in yellow needs to be answered. Some slots are filled, but i do not think I did it right so please DISREGARD those numbers. also, PLEASE SHOW EXCEL FORUMALS. thank you!
\begin{tabular}{|l|r|l|} \hline Unit Price & $600 \\ \hline Variable Cost per Unit & $400 \\ \hline Monthly Fixed Costs & $80,000 \end{tabular} Revenues Sales Terms Breakdown \begin{tabular}{|l|l|} \hline Cash sales & 50.00% cash \\ \hline One month credit sales & 25.00% one month credit \\ \hline Two months credit sales & 25.00% two month credit \\ \hline \end{tabular} a) Before raising capital, the owner would like to know how the company's Cash Flow would look like for the next six months (January through June). Using the templates below, please prepare respective schedules and cash budget There was no data in the green box here so I assumed it was 600 Cost of Goods Sold Schedule b) Current forecasts are made based on the unit price of $1,000, The owner would like to know the dollar break-even for this assumption. He would also like to know to how unites should be sold to breakeven, and what the break-even in the "number of units" \begin{tabular}{|l|r|l|} \hline Unit Price & $600 \\ \hline Variable Cost per Unit & $400 \\ \hline Monthly Fixed Costs & $80,000 \end{tabular} Revenues Sales Terms Breakdown \begin{tabular}{|l|l|} \hline Cash sales & 50.00% cash \\ \hline One month credit sales & 25.00% one month credit \\ \hline Two months credit sales & 25.00% two month credit \\ \hline \end{tabular} a) Before raising capital, the owner would like to know how the company's Cash Flow would look like for the next six months (January through June). Using the templates below, please prepare respective schedules and cash budget There was no data in the green box here so I assumed it was 600 Cost of Goods Sold Schedule b) Current forecasts are made based on the unit price of $1,000, The owner would like to know the dollar break-even for this assumption. He would also like to know to how unites should be sold to breakeven, and what the break-even in the "number of units
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