Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1. The Morning Jolt Coffee Company has projected the following quarterly sales amounts for the coming year: Q1 Q2 Q3 Q4 Sales $ 770 $

1. The Morning Jolt Coffee Company has projected the following quarterly sales amounts for the coming year:

Q1 Q2 Q3 Q4
Sales $ 770 $ 800 $ 880 $ 960

a.

Accounts receivable at the beginning of the year are $360. The company has a 45-day collection period. Calculate cash collections in each of the four quarters by completing the following (Negative amounts should be indicated by a minus sign. Round your answers to 2 decimal places, e.g., 32.16.):

Q1 Q2 Q3 Q4
Beginning receivables $ $ $ $
Sales 770.00 800.00 880.00 960.00
Cash collections
Ending receivables $ $ $ $

b.

Recalculate the cash collections with a collection period of 60 days. (Negative amounts should be indicated by a minus sign. Round your answers to 2 decimal places, e.g., 32.16.)

Q1 Q2 Q3 Q4
Beginning receivables $ $ $ $
Sales 770.00 800.00 880.00 960.00
Cash collections
Ending receivables $ $ $ $

c.

Recalculate the cash collections with a collection period of 30 days. (Negative amounts should be indicated by a minus sign. Round your answers to 2 decimal places, e.g., 32.16.)

Q1 Q2 Q3 Q4
Beginning receivables $ $ $ $
Sales 770.00 800.00 880.00 960.00
Cash collections
Ending receivables $ $ $ $

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

Financial Analysis And Modeling Using Excel And VBA

Authors: Chandan Sengupta

2nd Edition

047027560X, 978-0470275603

More Books

Students also viewed these Finance questions