Assume that Wildcat can borrow any needed funds on a short-term basis at a rate of 3 percent per quarter and can invest any excess funds in short-term marketable securities at a rate of 2 percent per quarter. b-1. Complete the following short-term financial plan for Wildcat, Incorporated. Note: A negative answer should be indicated by a minus sign. Do not round intermediate calculations and enter your answers in millions, not dollars, rounded to 2 decimal places, e.g., 32.16. Leave no cells blank - be certain to enter "O" wherever required. Target cash balance WILDCAT, INCORPORATED Short-Term Financial Plan (in millions) Q1 Q2 Q3 Q4 $ 30.00 $ 30.00 $ 30.00 $ 30.00 Net cash inflow New short-term investments 0.00 Income from short-term investments Short-term investments sold 0.00 0.00 0.00 New short-term borrowing 0.00 0.00 0.00 0.00 Interest on short-term borrowing 0.00 0.00 0.00 0.00 Short-term borrowing repaid 0.00 0.00 0.00 0.00 Ending cash balance Minimum cash balance -30.00 -30.00 -30.00 -30.00 Cumulative surplus (deficit) Beginning short-term investments Ending short-term investments Beginning short-term debt $ 0.00 $ 0.00 $ 0.00 $ 0.00 Ending short-term debt $ 0.00 $ 0.00 $ 0.00 $ 0.00

Essentials Of Investments
11th Edition
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Chapter1: Investments: Background And Issues
Section: Chapter Questions
Problem 1PS
Question

Please help filling out the rest of the table

Assume that Wildcat can borrow any needed funds on a short-term basis at a rate of 3 percent per quarter and can invest any excess
funds in short-term marketable securities at a rate of 2 percent per quarter.
b-1. Complete the following short-term financial plan for Wildcat, Incorporated.
Note: A negative answer should be indicated by a minus sign. Do not round intermediate calculations and enter your answers in
millions, not dollars, rounded to 2 decimal places, e.g., 32.16. Leave no cells blank - be certain to enter "O" wherever required.
Target cash balance
WILDCAT, INCORPORATED
Short-Term Financial Plan
(in millions)
Q1
Q2
Q3
Q4
$
30.00 $
30.00 $
30.00 $
30.00
Net cash inflow
New short-term investments
0.00
Income from short-term investments
Short-term investments sold
0.00
0.00
0.00
New short-term borrowing
0.00
0.00
0.00
0.00
Interest on short-term borrowing
0.00
0.00
0.00
0.00
Short-term borrowing repaid
0.00
0.00
0.00
0.00
Ending cash balance
Minimum cash balance
-30.00
-30.00
-30.00
-30.00
Cumulative surplus (deficit)
Beginning short-term investments
Ending short-term investments
Beginning short-term debt
$
0.00 $
0.00 $
0.00
$
0.00
Ending short-term debt
$
0.00 $
0.00
$
0.00
$
0.00
Transcribed Image Text:Assume that Wildcat can borrow any needed funds on a short-term basis at a rate of 3 percent per quarter and can invest any excess funds in short-term marketable securities at a rate of 2 percent per quarter. b-1. Complete the following short-term financial plan for Wildcat, Incorporated. Note: A negative answer should be indicated by a minus sign. Do not round intermediate calculations and enter your answers in millions, not dollars, rounded to 2 decimal places, e.g., 32.16. Leave no cells blank - be certain to enter "O" wherever required. Target cash balance WILDCAT, INCORPORATED Short-Term Financial Plan (in millions) Q1 Q2 Q3 Q4 $ 30.00 $ 30.00 $ 30.00 $ 30.00 Net cash inflow New short-term investments 0.00 Income from short-term investments Short-term investments sold 0.00 0.00 0.00 New short-term borrowing 0.00 0.00 0.00 0.00 Interest on short-term borrowing 0.00 0.00 0.00 0.00 Short-term borrowing repaid 0.00 0.00 0.00 0.00 Ending cash balance Minimum cash balance -30.00 -30.00 -30.00 -30.00 Cumulative surplus (deficit) Beginning short-term investments Ending short-term investments Beginning short-term debt $ 0.00 $ 0.00 $ 0.00 $ 0.00 Ending short-term debt $ 0.00 $ 0.00 $ 0.00 $ 0.00
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Recommended textbooks for you
Essentials Of Investments
Essentials Of Investments
Finance
ISBN:
9781260013924
Author:
Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:
Mcgraw-hill Education,
FUNDAMENTALS OF CORPORATE FINANCE
FUNDAMENTALS OF CORPORATE FINANCE
Finance
ISBN:
9781260013962
Author:
BREALEY
Publisher:
RENT MCG
Financial Management: Theory & Practice
Financial Management: Theory & Practice
Finance
ISBN:
9781337909730
Author:
Brigham
Publisher:
Cengage
Foundations Of Finance
Foundations Of Finance
Finance
ISBN:
9780134897264
Author:
KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:
Pearson,
Fundamentals of Financial Management (MindTap Cou…
Fundamentals of Financial Management (MindTap Cou…
Finance
ISBN:
9781337395250
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Finance
ISBN:
9780077861759
Author:
Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor
Publisher:
McGraw-Hill Education