Question 1
The Guillermo Furniture Store Scenario ? Write a paper of at least 1,500 words that focuses on the different alternatives available to Guillermo. ? Prepare an Income Statement for each of the alternatives from the data provided. Compare the results of the two new alternatives to the existing operations and explain the causes for the differences (contribution margins, volumes, leverage, fixed costs, sensitivity analysis, etc.) Assume for the Hi-Tech alternative the new equipment can be leased from the manufacturer for five years at a monthly cost of $23,000 and treated as an operating lease. ? Determine the weighted average cost of capital for the existing operations and each of the two alternatives. Assume the equity (market) value of the company is 0.70 sales and the market value of the debt is equal to the balance sheet value. Compute the required rate of return on equity using the CAPM formula: the risk free rate is 3%, the market rate is 12%, the beta for existing operations is 1.5, the beta for the hi tech alternative is 1.8 and the beta for the broker alternative is 1.2. The cost of debt and the tax rate are as given in the data provided. ? Discuss the factors that affect the risk of a typical project (Chapter 8) and how they might influence a project?s risk (discount rate) versus the firm?s risk (WACC).,No formatting or referencing is necessary. Simply data. Don't bother with word counts or anything,I just attempted to send the data. Not sure if you received it or not.,I am sending file which is financial data. Another general info file is following this one.,This is the general info file,Any ETA?,One question. There are references mentioned but there is no reference page.
Question 2
1) A dairy allocates the cost of unprocessed milk to the production of milk, cream, butter and cheese. For the current period, unprocessed milk was purchased for $320,000, and the following quantities of product and sales revenues were produced. Product Pounds Price per Pound Milk 140,000 $1.30 Cheese 54,000 2.60 Butter 24,000 5.00 Cream 14,000 7.00 How much of the $320,000 cost should be allocated to milk? (Do not round your intermediate calculations.) 2) A retail store has three departments, 1, 2, and 3, and does general advertising that benefits all departments. Advertising expense totaled $47,000 for the year, and departmental sales were as follows. Allocate advertising expense to Department 2 based on departmental sales. (Do not round your intermediate calculations.) Department 1 $111,000 Department 2 217,650 Department 3 141,350 3) Abbe Company reported the following financial numbers for one of its divisions for the year; average total assets of $4,300,000; sales of $4,725,000; cost of goods sold of $2,750,000; and operating expenses of $1,572,000. Assume a target income of 8% of average invested assets. Compute residual income for the division? 4) During its most recent fiscal year, Simon Enterprises sold 270,000 electric screwdrivers at a price of $17.10 each. Fixed costs amounted to $729,000 and pretax income was $999,000. What amount should have been reported as variable costs in the company's contribution margin income statement for the year in question? 5)A company has fixed costs of $87,000. Its contribution margin ratio is 29% and the product sells for $72 per unit. What is the company's break-even point in dollar sales? 6)Use the following information to determine the margin of safety in dollars (Do not round intermediate calculations): Unit sales 63,000 Units Dollar sales $630,000 Fixed costs $209,728 Variable costs $226,800 7)In Davis Corporation's most recent fiscal year, the company reported pretax earnings of $215,000. Fixed costs totaled $325,800, the unit selling price of the firm's only product was $60, and the variable costs per unit were 40% of the selling price. Based on this information, what was the firm's break-even point in units? 8)A June sales forecast projects that 6,600 units are going to be sold at a price of $11.1 per unit. The desired ending inventory of units is 15% higher than the beginning inventory of 1,600 units. What are total June sales are anticipated? 9)Fairway's April sales forecast projects that 7,800 units will sell at a price of $12.30 per unit. The desired ending inventory is 20% higher than the beginning inventory, which was 2,800 units. What are Budgeted purchases of units in April? 10)If budgeted beginning inventory is $8,750, budgeted ending inventory is $9,940, and budgeted cost of goods sold is $10,710, what are budgeted purchases? 11)Use the following information to determine the ending cash balance to be reported on the month ended June 30 cash budget. a. Beginning cash balance on June 1, $95,200. b. Cash receipts from sales, $419,000. c. Budgeted cash disbursements for purchases, $274,000. d. Budgeted cash disbursements for salaries, $96,200. e. Other budgeted expenses, $58,200. d. Cash repayment of bank loan, $33,200. e. Budgeted depreciation expense, $35,200.
Question 3
I need help in a revenue recognition Questions! Question 1: Pat's Electronics Division sells computers through agents in various cities. Agents send orders and down payments to our company. The division then ships the goods F.O.B. shipping point directly to the customers. Revenue is recognized at the point of sale. Additional Financial Data: Orders for fiscal year 2012 $ 3,000,000 Down Payments collected in 2012 $ 300,000 Billed and shipped in 2012 $ 2,400,000 Freight billed in 2012 $ 70,000 Commissions paid to Agents (after ship to customer) 10% Warranty Returns as % of Sales 1% Question 2: Peace Book Distribution Division Our book distribution division sells to national bookstores. Our division allows for up to 25% of sales in returns. For the past 4 years, returns have averaged 20%. We record revenue based on revenue recognition when the right of return exists. Total Sales for 2012 $ 9,000,000 Sales Still Available for return for six months $ 2,000,000 Actual Returns on Sales not returnable 21% 2011 Sales collected in 2012 $ 2,500,000 2011 Sales returned in 2012 19% For Both Questions, please Calculate the revenue to be recognized in fiscal year 2012 for each of Patty Corporation in accordance with generally accepted accounting principles. Show all calculations in excel. Thank you
Question 4
QP5-14 Interest Rate Risk Laurel, Inc., and Hardy Corp. both have 5.25 percent coupon bonds outstanding, with semiannual interest payments, and both are priced at par value. The Laurel, Inc., bond has 3 years to maturity, whereas the Hardy Corp. bond has 20 years to maturity. Requirement 1: If interest rates suddenly rise by 3.75 percent, what is the percentage change in the price of these bonds? (Negative amount should be indicated by a minus sign. Input your answers as a percent rounded to 2 decimal places, without the percent sign. (e.g., 32.16)) Percentage change Laurel ____________ percent Hardy ____________ percent Requirement 2: If interest rates were to suddenly fall by 3.75 percent instead, what would the percentage change in the price of these bonds be then? (Input your answers as a percent rounded to 2 decimal places, without the percent sign. (e.g., 32.16)) Percentage change Laurel ____________ percent Hardy ____________ percent Requirement 3: What does this problem tell you about the interest rate risk of longer-term bonds? (a) The longer the maturity of a bond, the greater is its price sensitivity to changes in interest rates. (b) The longer the maturity of a bond, the lesser is its price sensitivity to changes in interest rates.
Question 5
Hello, I have the following problem that I have been working on and need help. I posted this question already and hope the same instructor will get this. It is not a duplicate. The one I posted first is due next weekend. It is the same problem, but for the acquisition/payment process. This one below is due TONIGHT and is the same problem but is for the SALES/COLLECTION process. If you are the same professor and you can do both separately for the first $50 have pending on my first submission, great. If not, please do this one first (the sales/collection process) and it will be an additional $50. If you do them both (but it must be two total different diagrams) for the original $50, please cancel this one. Thank you and please accept my apologies for posting this again. " Quandrax Computers is a store that buys computer components for low prices, assembles the components into computers, and then sells the computers at high prices. Each computer is assigned a unique identification number, and computers that have common configurations are categorized into types (e.g. Longitude is a laptop that is easily networked and is recommended for businesses, Element is a desktop that is intended for home and small businesses). Categories can be entered into the database before any computers in the categories are actually assembled. The computer components are purchased from wholesalers. One of Quandrax?s purchasing agents submits an order to the wholesaler that has listed a given component for sale. If the order is accepted, one of Quandrax?s inventory clerks receives the items. Multiple orders accepted by the same supplier may be consolidated into one purchase. Orders are accepted in their entirety or not at all. Nearly all of Quandrax?s orders are accepted. Sometimes the incorrect components are delivered to Quandrax and Quandrax has to return them to the appropriate supplier. Sometimes Quandrax returns components to suppliers for other reasons, such as the result of a change in planned production of a certain category of computers. Only about 10 percent of Quandrax?s purchased components are returned to suppliers, and any return would result from only one purchase. When payment is due for a purchase, one of Quandrax?s cashiers issues one check for payment in full for the items on that purchase. Sometimes if multiple purchases have been made from the same supplier within a short time, Quandrax pays for those purchases with just one check. One of Quandrax?s managers is required to not only authorize all purchase orders greater than $5,000 but also to sign all checks (including checks written for expenditures other than purchases of computer components). Quandrax needs to keep track of the managers? participation in these events as well as the participation of other employees in these events. In physically implementing the conceptual model into the database tables, Quandrax wants to combine all employee types into just one table. This means Quandrax would keep the separate employee entities on the E-R diagram, but make just one employee table to represent all of the employee entities, then post keys or make relationship tables as necessary to implement all relationships of employees to the relevant events. All sales are handled via mail or e-mail, as Quandrax does not have any showrooms. Quandrax assigns salespeople to its large corporate customers and the salespeople take sample computers to the customer locations to demonstrate features as part of their sales calls. Only a small percentage of Quandrax?s sales calls result in orders, and sometimes a salesperson might need to make several sales calls to the same customer to obtain one order from that customer. Orders also result from customers surfing the Internet and seeing descriptions of the computers on Quandrax?s website. These customers are not assigned to specific salespeople; Quandrax only tracks the salesperson that actually took the order. Some of Quandrax?s salespeople are hired to handle just such orders and as such are not assigned specifically to any customers. If a customer orders multiple computers on one sale order and some of the computers are immediately available whereas the others are not yet assembled, Quandrax ships the available computers right away and then ships the remainder of the order when the rest of the computers are assembled. Sometimes Quandrax combines computers from multiple sale orders into a single shipment. For example, once a customer ordered 10 computers and the next day decided that wouldn?t be enough so he ordered 4 more. Quandrax shipped all 14 computers in one shipment. Quandrax only accepts checks for its sales of computers; customers can pay for multiple sales with a single check, but no partial payments are accepted. Each sale transaction is tracked by a shipment ID; an invoice is sent to the customer that is due within 10 days, with no discounts allowed. Quandrax does not allow any sale returns, that is, all sales are final. Cash receipts are never split between two cash accounts; rather each receipt is assigned to one of Quandrax?s cash accounts by one of Quandrax?s cashiers. Quandrax also receives cash from other activities such as loans, so the database must allow for that. Suppliers, employees, and customers need to be entered into the database before any transactions involving them occur. The following attributes are of interest to Quandrax; some are related to the acquisition/payment cycle. The attributes that are related to the sales/collection process must be included in your solution. Do not add attributes to the list. Use the boldface attribute abbreviations in parentheses next to the attributes in the list. List any assumptions you make, along with the reasons behind your assumptions (i.e., state what you think is vague in the problem, say what you are going to assume to clear up the ambiguity, and make a case for that assumption). Purchase Order Number (PO#) Sales Call ID (SC-ID) Supplier ID (SuppID) Cash Receipt ID (CR-ID) Employee ID (EmpID) Customer ID (Cust-ID) Purchase Order Date (PODate) Date of cash receipt (CR-Date) Purchase Date (PurchDate) Name of Customer (Cust-Name) Location of cash account (Ca-Loc) Total sale dollar amount (Sale-Amt) Cash Account Number (CashAcct#) Type of employee (EmpType) Name of supplier (SupName) Date of sale order (SO-Date) Receiving Report Number (RR#) Date of purchase return (PR-Date) Computer Category ID code (Cat-ID) Dollar amount of cash receipt (CR-Amt) Component ID code (CompoID) Current balance of cash account (AcctBal) Cash Disbursement Date (CD-Date) Shipping address for a customer (Cust-Ship) Name of employee (EmpName) Date of sale/shipment of computers (Ship-Date) Purchase return ID (PR-ID) Description of a computer category (Cat-Desc) Cash Disbursement Number (CD#) Computer component description (Comp-desc) Sale Order ID (SO-ID) Total dollar amount of a cash disbursement (CD-Amt) Shipment ID (Ship-ID) Standard cost for a computer component (Std-Cost) Date of sales call (SC-Date) Quantity of a computer component returned (Qty-Ret) Customer check number (CR-Chk#) Type of supplier (wholesaler or individual) (SupType) Identification number for a finished computer (CompuID) Quantity of a computer component ordered on purchase order (Qty-Ord) Proposed selling price for a type of computer on a sales call (Prop-SP) Ordered cost for a computer component on a purchase order (PO-Unit-Cost) Suggested selling price for computers [hint: by category] (List-price) Date assembly was completed for a finished computer (Assemb-Date) Quoted selling price for each item on a sale order (Ord-SP) Actual selling price for a particular finished computer (Act-SP) Quantity of a computer component received on a purchase (Qty-Rec) Actual cost of a computer component on a particular purchase (Item-Unit-Cost) Required: Create a business process level REA model (in either grammar or diagram format) for Quandrax Computers? saled/collection process. Be sure to include all relevant entities, relationships, attributes, and participation cardinalities.,By the way, the assignment comes from the text "Enterprise Information Systems" by Dunn, Cherrington, & Hollander. Chapter 8--applied learning exersise A1.
