Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Andrea Pedersen, the Treasurer for Wood Products, Inc. has just been asked by Justin Wood, the company's president, to prepare a memo detailing the company's

image text in transcribedAndrea Pedersen, the Treasurer for Wood Products, Inc. has just been asked by Justin Wood, the company's president, to prepare a memo detailing the company's ending cash balance for the next 3 months. Below, you will see the relevant estimates for this period.
July August September
Credit sales $1,275,800 $1,483,500 $1,096,300
Credit purchases 765,480 890,160 657,780
Cash disbursements
Wages, taxes, and expenses 348,600 395,620 337,150
Interest 29,900 29,900 29,900
Equipment - 158,900 96,300
Credit sales collections:
Collected in month of sale: 35%
Collected month after sale: 60%
Never collected: 5%
June credit sales: $1,135,020
June credit purchases: $681,012
Beginning cash balance: $425,000
All credit purchases are paid in the month after the purchase.
Complete the cash budget for Wood Products for the next three months.
Andrea knows that the cash budget will become a standard report completed before each quarter. To help reduce the time preparing the report each quarter, she would like a memo (in Excel too) with the appropriate information in this Excel file linked to the memo. Prepare a memo to Justin that will automatically update when the values are changed in Excel.
Heidi Pedersen, the Treasurer for Wood Products, Inc. has just been asked by Justin Wood, the companys president, to prepare a memo detailing the companys ending cash balance for the next 3 months. Below, you will see the relevant estimates for this period. July August September Credit sales $1,275,800 3,500 $1,096,300 890,160 657,780 765,480 Credit purchases Cash disbursements 395,620 337,150 348,600 Wages, taxes, and expenses Interest 29,900 29,900 29,900 158,900 Equipment 96,300 Credit sales collections 35% Collected in month of sale Collected month after sale 60% Never collected: June credit sales: $1,135,020 $681,012 June credit purchases: Beginning cash balance: $425,000 All credit purchases are paid in the month after the purchase. a. Complete the cash budget for Wood Products for the next three months. Heidi knows that the cash budget will become a standard report completed before each quarter. To help reduce the time preparing the report each quarter, she would b. like a memo with the appropriate information in Excel linked to the memo. Prepare a memo to Justin that will automatically update when the values are changed in Excel

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 Institutions Management A Risk Management Approach

Authors: Anthony Saunders, Marcia Cornett, Otgo Erhemjamts

10th Edition

1260013820, 978-1260013825

More Books

Students also viewed these Finance questions

Question

What committees does the person serve on?

Answered: 1 week ago