What would a cash flow forecast for Viggio for the next six months look like? Please create a forecast based on the following estimates below

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
icon
Concept explainers
Question

What would a cash flow forecast for Viggio for the next six months look like? Please create a forecast based on the following estimates below

Viggio Estimates for Next Year
January
February
March
April
Мay
June
ТОТAL
Sales
$73,305
$58,644
$58,644
$87,966
$97,740 $112,401
$488,700
Monthly Purchases
$46,182
$36,946
$36,946
$55,419
$61,576
$70,813
$307,881
Mortgage payment
$10,000
$10,000
$10,000
$10,000
$10,000
$10,000
$60,000
Rent for storage area
$2,000
$2,000
$2,000
$2,000
$2,000
$2,000
$12,000
Utilities
$2,000
$2,200
$1,800
$1,500
$2,000
$2,300
$11,800
Marketing
$2,500
$2,100
$2,000
$2,200
$3,000
$2,500
$14,300
Insurance
$700
$700
$700
$700
$700
$700
$4,200
Salaries and Benefits
$5,000
$5,600
$5,000
$5,600
$6,400
$6,900
$34,500
Internet Website
Maintenance
$500
$500
$500
$500
$500
$500
$3,000
Repairs and
Maintenance
$500
$500
$500
$500
$500
$500
$3,000
Travel
$1,800
$800
$1,500
$1,000
$800
$800
$6,700
Supplies
$400
$400
$400
$400
$400
$400
$2,400
Loan Payments
$2,275
$2,275
$2,275
$2,275
$2,275
$2,275
$13,650
Tax Payments
$500
$560
$500
$560
$640
$690
$3,450
Annual Tax Payment
$35,000
$35,000
Misc.
$300
$300
$300
$300
$300
$300
$1,800
Transcribed Image Text:Viggio Estimates for Next Year January February March April Мay June ТОТAL Sales $73,305 $58,644 $58,644 $87,966 $97,740 $112,401 $488,700 Monthly Purchases $46,182 $36,946 $36,946 $55,419 $61,576 $70,813 $307,881 Mortgage payment $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $60,000 Rent for storage area $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $12,000 Utilities $2,000 $2,200 $1,800 $1,500 $2,000 $2,300 $11,800 Marketing $2,500 $2,100 $2,000 $2,200 $3,000 $2,500 $14,300 Insurance $700 $700 $700 $700 $700 $700 $4,200 Salaries and Benefits $5,000 $5,600 $5,000 $5,600 $6,400 $6,900 $34,500 Internet Website Maintenance $500 $500 $500 $500 $500 $500 $3,000 Repairs and Maintenance $500 $500 $500 $500 $500 $500 $3,000 Travel $1,800 $800 $1,500 $1,000 $800 $800 $6,700 Supplies $400 $400 $400 $400 $400 $400 $2,400 Loan Payments $2,275 $2,275 $2,275 $2,275 $2,275 $2,275 $13,650 Tax Payments $500 $560 $500 $560 $640 $690 $3,450 Annual Tax Payment $35,000 $35,000 Misc. $300 $300 $300 $300 $300 $300 $1,800
Expert Solution
Step 1

Cash flow statement:
Cash flow statement can be defined as the financial statement prepared by the business entity for the purpose of reporting the cash inflows and the outflows during specific period. It reflects the cash position of the business entity and liquidity in the business operation.

trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Cash Budget
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education