Schedule of Cash Payments for a Service Company Oakwood Financial Inc. was organized on February 28. Projected selling and administrative expenses for each of the first three months of operations are as follows: March April May $128,000 121,600 110,700 Depreciation, insurance, and property taxes represent $28,000 of the estimated monthly expenses. The annual insurance premium was paid on February 28, and property taxes for the year will be paid in June. 66% of the remainder of the expenses are expected to be paid in the month in which they are incurred, with the balance to be paid in the following month. Prepare a schedule indicating cash payments for selling and administrative expenses for March, April, and May.

Schedule of Cash Payments for a Service Company Oakwood Financial Inc. was organized on February 28. Projected selling and administrative expenses for each of the first three months of operations are as follows: March April May $128,000 121,600 110,700 Depreciation, insurance, and property taxes represent $28,000 of the estimated monthly expenses. The annual insurance premium was paid on February 28, and property taxes for the year will be paid in June. 66% of the remainder of the expenses are expected to be paid in the month in which they are incurred, with the balance to be paid in the following month. Prepare a schedule indicating cash payments for selling and administrative expenses for March, April, and May.

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Related questions

Q: As of December 31 (the end of the prior quarter), the company’s general ledger showed the following…

A: In this question, we need to prepare the cash budget for the quarter ended March 31. For that, we…

Q: Torres Company budgets merchandise purchases of $15,800 in January, $17,600 in February, and $22,200…

A: Cash payment is the amount of the payment expected to be made by the entity for the purchases of the…

Q: EastGate Physical Therapy Inc. is planning its cash payments for operations for the first quarter…

A: Budgeting is a process to prepare the financial statement by the manager to estimate the…

Q: Ivanhoe Company expects to have a cash balance of $51,750 on January 1, 2020. Relevant monthly…

A: Cash budget is the statement which is prepared by an entity to estimate the cash receipts and cash…

Q: A company's sales for January are $250,000. If the company projects warranty obligations to be 5% of…

A: A warranty is a provision created by a company by keeping aside funds which are a percentage of the…

Q: Lindor Enterprises projects sales for the first three months of the year to be: $10,400 in January,…

A: Cash Budget is an estimation of the cash inflows and cash outflows for the future period for that…

Q: Lindor Enterprises projects sales for the first three months of the year to be: $10,200 in January,…

A: The cash budget refers to the statement prepared by the management estimating future possible cash…

Q: In January ABC budgets to incur $100,000 of administrative expenses. 90% of these expenses will be…

A: Total administrative expenses of January = $100,000 Noncash administrative expenses of January =…

Q: As of December 31 (the end of the prior quarter), the company’s general ledger showed the following…

A: Balance sheet is a part of financial statements. It is also known as 'Statement of financial…

Q: Lindor Enterprises projects sales for the first three months of the year to be: $10,400 in January,…

A: A cash budget is an estimation of the cash flows of a business over a specific period of time. This…

Q: rent Assets all Hanson Construction has an operating cycle of 9 months. On December 31, 2019, Hanson…

A: Step 1: Current Assets:a)Note receivable$1,200b)Cash$460d)Accounts receivable$8,000 Total current…

Q: A company's data regarding its operations follow: 1. Sales budget November $360,000 December…

A: The net income is transferred from the income statement to the retained earnings.. Dividends are…

Q: Urmilaben

A: The objective of the question is to prepare a monthly cash budget for the months of January,…

Q: A company needs to record six months of accrued interest on a four-year, 12%, $12,000 promissory…

A: Interest expense accrued = Promissory note payable x rate of interest x months/12

Q: Total sales Budgeted purchases of direct materials Budgeted direct labor cost Budgeted manufacturing…

A: A cash budget is prepared with the help of a cash collection schedule, cash payments schedule,…

Q: January February March Cash Receipts $525,000 400,000 450,000 Cash Payments $475,000 350,000 525,000…

A: Kayak Company's cashbudget for January to March ensures a minimum cash balance of $30,000monthly by…

Q: Thomas Company had the following information related to September 2020: 1) Depreciation on the…

A: Calculation for item 3 Payroll covering wages earned during the last week of September and…

Q: As of December 31 (the end of the prior quarter), the company’s general ledger showed the following…

A: A financial plan called a collections budget describes the anticipated cash inflows from customers…

Q: Thomas Company had the following information related to September 2020: 1) Depreciation on the…

A: 1. Wages for September month Net Payroll = 144,000 Salary related to september month only = 144,000…

Q: 2 Arrangon Ltd. is a company that manufactures and sells a single product called Zoltar. For…

A: Here is a summary of the key steps to prepare the master budget for Arrangon Ltd. for the year ended…

Q: Complete a Cash Budget for Lindor Enterprises.

A: Cash Budget is prepared to provide for the estimated cash requirements of the business entity.It…

Q: Complete a Cash Budget for Lindor Enterprises.

A: A cash budget is the method of analysing the progress of cash flows to the company and as this is…

Q: homas Company had the following information related to September 2020: 1) Depreciation on the store…

A: Interest expense for the month=Value of note payable×Interest rate×112

Q: Hillary's Health Food Store has estimated monthly current asset financing requirements for the next…

A: Solution:-a Calculation of dollar interest payments for the six months as follows under:-

Q: The Runner Antique Mall expects to make purchases in the first quarter of 2021 as follows: January…

A: Introduction: A cash disbursement is a payment made in exchange for goods or services. A cash…

Concept explainers

Master Budget

A master budget can be defined as an estimation of the revenue earned or expenses incurred over a specified period of time in the future and it is generally prepared on a periodic basis which can be either monthly, quarterly, half-yearly, or annually. It helps a business, an organization, or even an individual to manage the money effectively. A budget also helps in monitoring the performance of the people in the organization and helps in better decision-making.

Sales Budget and Selling

A budget is a financial plan designed by an undertaking for a definite period in future which acts as a major contributor towards enhancing the financial success of the business undertaking. The budget generally takes into account both current and future income and expenses.

Question

Schedule of Cash Payments for a Service Company
Oakwood Financial Inc. was organized on February 28. Projected selling and administrative expenses for each of the first three months of operations are as follows:
March
April
May
Depreciation, insurance, and property taxes represent $28,000 of the estimated monthly expenses. The annual insurance premium was paid on February 28, and
property taxes for the year will be paid in June. 66% of the remainder of the expenses are expected to be paid in the month in which they are incurred, with the
balance to be paid in the following month.
$128,000
121,600
110,700
Prepare a schedule indicating cash payments for selling and administrative expenses for March, April, and May.
Oakwood Financial Inc.
Schedule of Cash Payments for Selling and
Administrative Expenses
For the Three Months Ending May 31
March April
March expenses:
Paid in March
Paid in April
April expenses:
Paid in April
Paid in May
May expenses:
Paid in May
Total cash payments
May
Q00

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1: Introduction

VIEW

Step 2: Calculation

VIEW

Solution

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 3 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

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

Flint, Inc. provided the following information: Projected merchandise purchases . March April $67,000 $75,000 Budgeted cash disbursements $ Flint pays for 40% of merchandise purchases in the month of the purchase and 60% in the following month. General operating expenses are budgeted to be $25,000 per month of which depreciation is $2,000 of this amount. Flint pays operating expenses in the month incurred. Calculate Flint's budgeted cash disbursements for May. May $81,000
Sydney Corporation, a provider of cable television, projects the following revenues: August September October $205,000 220,000 238,000 250,000 290,000 November December Total expenses are equal to 35 percent of the current month's revenues. Of this amount, $12,000 represents depreciation. Sixty percent of all accounts payable for expenses are paid for in the month incurred, with the remainder being paid in the following month. Compute the budgeted cash disbursements during November: $
rr
Dog
The following budget information is available for the HD Sales Company (HDC) for January: Sales $415,000 Freight out $0.20 per unit sold Depreciation on Administrative Equipment $19,500 Sales & Administrative Salaries $51,400 + 3% of sales Advertising $21,500 Depreciation on Manufacturing Equipment $24,500 Lease on Sales Building $48,800 Miscellaneous Selling Expenses $6,900 All operating expenses are paid in cash in the month incurred. If HDC expects to sell 29,500 units of inventory, the total budgeted selling and administrative expenses would be what amount on the January pro forma income statement? Multiple Choice $345,950 $146,950 $166,450 $190,950
Scrimiger Paints wants to upgrade its machinery and on September 20 takes out a loan from the bank in the amount of $670,000. The terms of the loan are 3.8% annual interest rate and payable in 8 months. Interest is due in equal payments each month. A. Compute the interest expense due each month. If required, round final answer to two decimal places. B. Show the journal entry to recognize the interest payment on October 20, and the entry for payment of the short-term note and final interest payment on May 20. If required, round final answers to two decimal places. If an amount box does not require an entry, leave it blank. Oct. 20 May 20
Scrimiger Paints wants to upgrade its machinery and on September 20 takes out a loan from the bank in the amount of $640,000. The terms of the loan are 3.1% annual interest rate and payable in 8 months. Interest is due in equal payments each month. A. Compute the interest expense due each month. If required, round final answer to two decimal places. 1,653.33 B. Show the journal entry to recognize the interest payment on October 20, and the entry for payment of the short-term note and final interest payment on May 20. If required, round final answers to two decimal places. If an amount box does not require an entry, leave it blank. 1,653.33 Oct. 20 Interest Expense Cash May 20 Cash 1,653.33 640,000 1,653.33 641,653.33
Karim Corp. requires a minimum $9,000 cash balance. Loans taken to meet this requirement cost 1% interest per month (paid monthly). Any excess cash is used to repay loans at month-end. The cash balance on July 1 is $9,400, and the company has no outstanding loans. Forecasted cash receipts (other than for loans received) and forecasted cash payments (other than for loan or interest payments) follow. July August September Cash receipts $ 25,000 $ 33,000 $ 41,000 Cash payments 29,500 31,000 33,000 Prepare a cash budget for July, August, and September. (Negative balances and Loan repayment amounts (if any) should be indicated with minus sign. Round your final answers to the nearest whole dollar.) KARIM CORP. Cash Budget For July, August, and September July August September Beginning cash balance $9,400 Total cash available Preliminary cash balance Ending cash…
6