Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1. Calculate the projected Cash Receipts for the three months of February, March, and April (Tables have been set up for you) (30 pts) Sales

1. Calculate the projected Cash Receipts for the three months of February, March, and April (Tables have been set up for you) (30 pts)

Sales forecast

December

January

February

March

April

Cash Sales

Collection of AR:

Lagged 1 Month

Lagged 2 Months

Other Cash Receipts

Total Cash Receipts

2. Calculate the projected Cash Disbursements for the same months

A Schedule of Projected Cash Disbursements for Joseph Pharmacy (30 points)

Sales

December

January

February

March

April

Purchases

(50% of next months sales)

Rent payments

Wages/Salaries

Total

Indicate what the total cash balance would be at the end of these three months if the cash balance at the beginning of February was $1,500. (40 points)

February Cash balance

Total Cash Receipts

December

January

February

March

April

Cash Disbursements

Balance

Balance from Feb - April

****To keep it fair to all, I am going to provide you with the ending cash balance for Feb. You should have $-9,250.****

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

DeFi And The Future Of Finance

Authors: Campbell R. Harvey, Ashwin Ramachandran, Joey Santoro, Vitalik Buterin, Fred Ehrsam

1st Edition

1119836018, 978-1119836018

More Books

Students also viewed these Finance questions