Attachment # 00001958 - ch6-05.xlsx
ch6-05.xlsx (12.81 KB)
Raw Preview of Attachment:
(refer to the detailed question and attachment below)
Loan proceedsLoan paymentsChange in cashBeginning cashEnding cashPurchasesCost of expected salesRequired ending inventoryBeginning inventoryCash payments for purchasesOperating activitiesCash from (to) operating activitiesCash from (to) financing activitiesCash from (to) investing activitiesFinancing activitiesInvesting activitiesProduct sales revenueAssumptionsOperating cash receiptsOperating cash paymentsCash BudgetAdvertising expenseUtilities expenseInterest expenseSupplies expenseExpensesWine DepotCollections in the year of saleCollections in the year following salePayments in the year of purchasePayments in the year following purchaseMarketing expenseSalaries expenseWages expenseFacility purchasesEquipment sales
The Wine Depot is contemplating several alternative means of financing their annual acquisition of $75,000

The Wine Depot is contemplating several alternative means of financing their annual acquisition of $75,000

Question # 00026688 Posted By: jia_andy Updated on: 09/25/2014 07:57 AM Due on: 02/28/2015
Subject Accounting Topic Accounting Tutorials:
Question
Dot Image
Wine Depot
Cash Budget 2010 2011 2012 2013
Operating activities
Operating cash receipts
Product sales revenue
Collections in the year of sale
Collections in the year following sale
Operating cash receipts
Operating cash payments
Purchases
Cost of expected sales
Required ending inventory
Beginning inventory
Purchases
Payments in the year of purchase
Payments in the year following purchase
Cash payments for purchases
Expenses
Advertising expense
Marketing expense
Interest expense
Salaries expense
Wages expense
Supplies expense
Utilities expense
Expenses
Operating cash payments
Cash from (to) operating activities
Investing activities
Facility purchases
Equipment sales
Cash from (to) investing activities
Financing activities
Loan proceeds
Loan payments
Cash from (to) financing activities
Change in cash
Beginning cash
Ending cash
Assumptions
Dot Image
Attachments
Chapter_6_instructions_(1).docx (15.89 KB)
ch6-05.xlsx (12.81 KB)
Tutorials for this Question
  1. jia_andy
    Tutorial # 00026117 Posted By: jia_andy Posted on: 09/25/2014 07:58 AM
    Puchased By: 3
    Tutorial Preview
    The solution of The Wine Depot is contemplating several alternative means of financing their annual acquisition of $75,000...
      Get the Solution
    Attachments
    Ch6-05_Student_Name.xlsx (18.01 KB)
    Ch6-05_Student_Name-Formula_View.xlsx (18.02 KB)
Whatsapp Lisa