Question: half my values are wrong in the given tables for the following questions along with my net cash costs: WILDCAT, INCORPORATED Short - Term Financial

half my values are wrong in the given tables for the following questions along with my net cash costs:
WILDCAT, INCORPORATED Short-Term Financial Plan (in millions) Q1 Q2 Q3 Q4 Target cash balance $ 20.00 $ 20.00 $ 20.00 $ 20.00 Net cash inflow 108.33-109.8819.8348.17 New short-term investments 88.330.000.0028.17 Income on short-term investments 1.770.000.000.56 Short-term investments sold 0.0088.330.000.00 New short-term borrowing 0.0021.550.000.00 Interest on short-term borrowing 0.000.650.000.00 Short-term borrowing repaid 0.000.0010.779.83 Ending cash balance Minimum cash balance -20.00-20.00-20.00-20.00 Cumulative surplus (deficit) $ 88.33 $ 0.00 $ 0.00 $ 28.17 Beginning short-term investments $ 0.00 $ 88.33 $ 0.00 $ 0.00 Ending short-term investments $ 88.33 $ 0.00 $ 0.00 $ 28.17 Beginning short-term debt $ 0.00 $ 0.00 $ 21.55 $ 9.83 Ending short-term debt $ 0.00 $ 21.55 $ 9.83 $ 0.00
a-2. What is the net cash cost for the year under this target cash balance?
Note: A negative answer should be indicated by a minus sign. Enter your answer in millions. Do not round intermediate
calculations and round your answer to 2 decimal places, e.g.,32.16.
WILDCAT, INCORPQRATED Short-Ferm Financial Plan (lin millions) Qt Q2 Q3 Q4 Target cash baiance $ 40.00540.00 $ 40.00540.00 Net cash intiow 108.331-109.8849.83^(1)48.17 New short-term investmenta 88.330.000.008.17 Income on short-ferm investrnents 1.370.0070.00}0.16 Shorf-term investrnents sold 0.00768.33^("a ")0.0070.001 New short-term borrowing 0.00741.55^("a ")0.0070.00 Interest on shori-term borrowing 0.001.250,0010.00 Short-ferm bortowing ropaid 0.00?0.0021.7218.83 Endirg cash balance 540.00?340.007540.00?340.00. Minumum cash balance 40.00.40.00-40.00.40.00 Cumulative surplus (deficit)568.33 $ 0.0050.009 $ 8.171 Buginning short-tarm investments 50.00} $ 68.3350.00^(2) $ 0.00 Ending short-fertr investments 568.33^(7) $ 0.00 $ 0.007 $ 8.17 Beginning short-term debt 50.00750.00541.55 $ 19.83 Eriding short-term debt 50.00 $ 41.55519.83 $ 0.00
b-2. What is the net cash cost for the year under this target cash balance?
Note: Enter your answer in millions. Do not round intermediate calculations and round your answer to 2 decimal places, e.g.,
32.16.
a-2. What is the net cash cost for the year under this target cash balance?
Note: A negative answer should be indicated by a minus sign. Enter your answer in millions. Do not round intermediate calculations and round your answer to 2 decimal places, e.g.,32.16.
b-1. Complete the following short-term financial plan assuming that Wildcat maintains a minimum cash balance of $20 million.
Note: Enter your answers in millions. Negative amounts should be indicated by a minus sign. Leave no cells blank - be certain to enter "0" wherever required. Do not round intermediate calculations and round your answers to 2 decimal places, e.g.,32.16.
b-2. What is the net cash cost for the year under this target cash balance?
Note: Enter your answer in millions. Do not round intermediate calculations and round your answer to 2 decimal places, e.g.,32.16.
half my values are wrong in the given tables for

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!