Question: Please show in excel Ocean View State Bank estimates that over the next 24 hours the following cash inflows and outflows will occur (all figures

Please show in excel

Ocean View State Bank estimates that over the next 24 hours the following cash inflows and outflows will occur (all figures in millions of dollars):

Deposit withdrawals $100

Sales of bank assets 40

Deposit inflows 95

Stockholder dividend payments 150

Scheduled loan repayments 90

Revenues from sale of non-deposit services 95

Acceptable loan requests 60

Repayments of bank borrowings 60

Borrowings from the money market 80

Operating expenses 50

What is this banks projected net liquidity position in the next 24 hours? From what sources can the bank cover its liquidity needs?

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 Finance Questions!

Q:

The uniform sign has a weight of 1500 lb and is supported by the pipe AB, which has an inner radius of 2.75 in. and an outer radius of 3.00 in. If the face of the sign is subjected to a uniform wind...

Q:

1. Ocean View State Bank estimates that over the next 24 hours the following cash inflows and outflows will occur (all figures in millions of dollars): Deposit withdrawals Deposit inflows Scheduled...

Q:

Ocean View State Bank estimates that over the next 24 hours the following cash inflows and outflows will occur (all figures in millions of dollars): What is this banks projected net liquidity...

Q:

Emerging State Bank estimates that over the next 24 hours the following cash inflows and outflows will occur (all figures in millions of rand): Deposit withdrawals R200 Sales of bank assets R 80...

Q:

3 pointsSave A PNC Bank estimates that over the next 24 hours the following cash inflows and outflows will occur (all figures in millions of dollars: $100 Saes of bank assets Deposit withdrawals...

Q:

SECTION II: Complete problems within the provided Problem 1. Liquidity Management (20 points) ABC Bank estimates that over the next week the following cash inflow and outflows will occur (all figures...

Q:

Please process at your earliest convenience. I have enclosed the attached document and other required documents. Thank you for your help! Consider how Kyler Valley Spring Park Lodge could use capital...

Q:

(Questions from Lecture and Article) - Discussion Board Activity I need to read the following Lecture Note and the ?Wall Street Journal? articles that I uploaded, and writeanswers for theDiscussion...

Q:

It was 3 a.m. when the wake-up call startled Steve McKenzie out of deep sleep. McKenzie, a management consultant from New Jersey, was glad to be finally leaving the Bon Star Hotel, a three-star hotel...

Q:

Below is the assignment, attached in the excel file is actually all the answers, I need these transferred into my own excel file, answering all the questions below. Integrated mini-case: ?Working...

Q:

Hi. I need Chapter 11 part 1-4 Let me know. Thanks! (it wont letme add more than $8, but I will give $12+ tip) Personal Finance, Fifth Edition by Jeff Madura BUILDING YOUR OWN FINANCIAL PLAN WORKBOOK...

Q:

Folmar Co. is considering the following alternative financing plans: Income tax is estimated at 40% of income.Determine the earnings per share of common stock, assuming income before bond interest...

Q:

What is the percentage of energy that should be localized in an H2O bond in order for a reactive collision to succeed? The steric factor is equal to 0.05 .

Q:

The weights in a company s weighted average cost of capital should be based on the: Group of answer choices Average debt and equity levels the company had in the last 1 0 years Debt and equity levels...

Q:

Check my work Required information The following information applies to the questions displayed below.) Nautical has two classes of stock authorized: $10 par preferred, and $1 par value common. As of...