Finance for Managers MGT-325-OL01 Sandi Tucker 11/14/17 8.56 PM Homework: Spread

Question

Finance for Managers MGT-325-OL01 Sandi Tucker 11/14/17 8.56 PM Homework: Spreadsheet Project Score: 0 of 5 pts P1-3 (similar to) Save 1 of 20 (0 complete) HW Score: 0%, 0 of 100 pts Question Help Cash flows It is typical for Jane to plan, monitor, and assess her financial position using cash flows over a given period, typically a month Jane has a savings account and her bank loans money at 6% per year while it offers short-term investment rates of 5% Jane's cash flows during August were as follows: EEB (Click on the icon located on the top-right comer of the data table in order to copy its contents into a spreadsheet) a. Determine Jane's total cash inflows and cash outflows b. Determine the net cash fiow for the month of August c. If there is a shortage, what are a few options open to Jane? d. If there is a surplus, what would be a prudent strategy for her to follow? Jane's total cash inflows are (Round to the nearest dollar, a. # II) More

Explanation / Answer

a.

Total Cash inflow = $430 + $4,500

= $4,930.

Total Cash inflow is $4,930.

Total Cash outflow = $1,200 + $510 + $760 + $354 + $270 + $1,290 + $223

= $4,607.

Total cash outflow is $4,607.

b.

Net cash flow = $4,930 - $4,607

= $323.

Net cash flow is $323.

c.

Since, total cash flow is more than cash outflow, so there is no shortage of cash flow.

d.

Since, total cash flow is more than cash outflow. So, she has surplus cash flow in month of august. prudent strategy for her to invest surplus cash for future use.

Related Questions

Navigate

• Browse (All)
• Browse F
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.