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
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
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps
Recommended textbooks for you
Essentials Of Investments
Finance
ISBN:
9781260013924
Author:
Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:
Mcgraw-hill Education,
Essentials Of Investments
Finance
ISBN:
9781260013924
Author:
Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:
Mcgraw-hill Education,
Foundations Of Finance
Finance
ISBN:
9780134897264
Author:
KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:
Pearson,
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…
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