Question 1
Open the file Prob 05-01. Xls. You will note that it has five worksheets, or ?tabs?. In this project, you will work only with three. You will not use the WACC or Proj. oNextf Financials and Valuation worksheets. The actual historical (2001 to 2003) financial statements for Van leer are shown in the rightmost tab, labeled Actual. a. The first task is to calculate the historical ratios as discussed in the text. Click on the Historical Analysis tab and fill in the yellow-shaded cells with formulas. Note that many cells have comments, indicated by a red triangle in the upper right hand corner. You can view the comments by letting your cursor hover above one of the cells, and they provide hints or instructions for filling in the cell. There are additional instructions in the sheet itself. You will calculate historical ratios and free cash flows in this worksheet. b. Next click on the Inputs tab to open that worksheet. In the Yellow cells, fill in the projected values for 2004 for the various ratios needed for projecting the operating results. Be careful no to enter anything in other cells (The values are given in Exhibit 5-4). c. Open the worksheet labeled Projection of FCF and use the projected ratios to build formulas that complete the 2004 projections (column D) of operating income entries in the income statement and the operating asset and liability entries in the balance sheet by entering appropriate formulas. For example, the estimate of 2004 sales will equal the actual 2003 sales multiplied by one plus the projected growth rate in sales. To enter the formula, click on cell D6, enter an ?=? sign, click on the adjacent cell, C6, type ?*(1+? then open the Inputs worksheet by clicking on the Inputs tab and click on the call containing the 2004 sales growth rate, which is C4. Now type a close parentheses, ?)?, hit the return key, and the formula will be entered as ?=C6*(1+ Inputs!C4)?, with the numerical result 1110.0. For another example, to get the estimate for COGS for 2004, we want to multiply the sale levels we just estimated by the COGS to sales ration. Click on cell E7, enter a ?=? sign, then click on cell D6 and then enter the ?*? sign. Now go to Inputs worksheet by clicking on the tab, then click on cell C5, and hit return . the formula entered should be ?=D6*Inputs!C5?, and the numerical result, 693.8 d. Finally, using the estimates for the operating portions of the balance sheet and income statements, estimate the components of the free cash flow in the middle section of the worksheet labeled Projection of FCF, again, by entering the appropriate formula?s into the cells. (Check your results against the projections in Exhibit 5-5. When your results agree with Exhibit 5-5, you have successfully completed the project).,Here is Exhibit 5-4 to go along with assignment,Here is Exhibit 5-5 to go with assignment
Question 2
hELLO , READ THE CASE then answer the 3 q as a report not in q and answer . provide 3 pages dubble spase plus exhabit,THANKS,this class for business Ethics are you familiar with this assignment if you accept my assignment ?,thanks,thanks so much,this is an important guide line to clarify the case just read it . Guidelines for Case Analysis in Business Ethics Ethical case analysis follows the same general outline but differs from a regular business school approach. Both look to the managerial skills of diagnosis, investigation, and decision-making. The ethical analysis demands more reasoned justification on the basis of normative theory ? that is, based on issues of what is good, right, just and fair. You will generally need to persuade your audience on grounds other than cost/benefit alone. Real life issues are complex and we often deal in partial knowledge of the whole situation. At the same time, decisions still need to be made and there is a risk that people will be hurt as a consequence. In many cases, it is not so much a question of right against wrong, but more, which is the course of action that is least wrong. The following steps will be important: 1. Know the facts and the situation. a. Who are the key actors? b. What happened? c. What was the context? d. Who knew what and when did they know it? 2. What indications were there that there was a problem? a. Are there other problems that suggest an underlying cause? 3. Who are the primary and secondary stakeholders in the case? 4. What are the interests of the stakeholders? a. When do they converge? b. When do they conflict? 5. What theoretical models are appropriate in this case? 6. How would you apply the models? 7. What are the most likely objections? 8. How would you convince an objector of the merits of your recommendation? 9. What action steps should be (or should have been) taken? 10. What is the criterion of success in this case? (How would you know you did the right thing?),use simple world to easy to understand and write as international student , do not write complex worlds .,, HELLO, just remember that The case analysis should be in the form of a report ( not a question and answer format,THANK YOU PROVIDE brife summary first, then analyze the case thanks,hello do not forget to add Exhabits i will send u some example,there r four Exhabits in the case make sure includ it,is tis assignment a litter from prison ? i have sent many assignment just to make sure,about the exhabits Exhibits should contain specific types of analyses (e.g., application of a framework, table of comparisons, cost analysis, and competitive features) and information (e.g., web page of firm) that supports and is relevant, but would be too detailed for the body of the paper.,thank for the work put can you add the Exhabits in the paper i do not know how to put them . thank u,hello, thanks but i do not want the screen in the exhabits do u have other idea how to add them without the screen thanks,thanks,hello , did u put the exhabits ?,"please answer me as soon as possible it is due tomorow "
Question 3
1. Payroll accounting. Assume that the following tax rates and payroll information pertain to Brookhaven Publishing: ? Social Security taxes: 6% on the first $55,000 earned ? Medicare taxes: 1.5% on the first $130,000 earned ? Federal income taxes withheld from wages: $7,500 ? State income taxes: 5% of gross earnings ? Insurance withholdings: 1% of gross earnings ? State unemployment taxes: 5.4% on the first $7,000 earned ? Federal unemployment taxes: 0.8% on the first $7,000 earned The company incurred a salary expense of $50,000 during February. All employees had earned less than $5,000 by month-end. a. Prepare the necessary entry to record Brookhaven?s February payroll. The entry will include deductions for the following: ? Social Security taxes ? Medicare taxes ? Federal income taxes withheld ? State income taxes ? Insurance withholdings b. Prepare the journal entry to record Brookhaven?s payroll tax expense. The entry will include the following: ? Matching Social Security taxes ? Matching Medicare taxes ? State unemployment taxes ? Federal unemployment taxes 2. Current liabilities: entries and disclosure. A review of selected financial activities of Visconti?s during 20XX disclosed the following: 12/1 Borrowed $20,000 from the First City Bank by signing a 3- month, 15% note payable. Interest and principal are due at maturity. 2/10 Established a warranty liability for the XY-80, a new product. Sales are expected to total 1,000 units during the month. Past experience with similar products indicates that 2% of the units will require repair, with warranty costs averaging $27 per unit. 12/22 Purchased $16,000 of merchandise on account from Oregon Company, terms 2/10, n/30. 12/26 Borrowed $5,000 from First City Bank; signed a note payable due in 60 days. 12/31 Repaired six XY-80s during the month at a total cost of $162. 12/31 Accrued 3 days of salaries at a total cost of $1,400. Instructions a. Prepare journal entries to record the transactions. b. Prepare adjusting entries on October 31 to record accrued interest. c. Prepare the Current Liability section of Red Bank?s balance sheet as of October 31. Assume that the Accounts Payable account totals $203,600 on this date. 3. Notes payable. Red Bank Enterprises was involved in the following transactions during the fiscal year ending October 31: 8/2: Borrowed $75,000 from the Bank of Kingsville by signing a 120-day note. 8/20: Issued a $40,000 note to Harris Motors for the purchase of a $40,000 de?livery truck. The note is due in 180 days and carries a 12% interest rate. 9/10: Purchased merchandise from Pans Enterprises in the amount of $15,000. Issued a 30-day, 12% note in settlement of the balance owed. 9/11: Issued a $60,000 note to Datatex Equipment in settlement of an overdue account payable of the same amount. The note is due in 30 days and car?ries a 14% interest rate. 10/10: The note to Pans Enterprises was paid in full. 10/31: The note to Datatex Equipment was paid in full. 11/30: Paid note to Bank of Kingville Instructions a. Prepare journal entries to record the transactions. b. Prepare adjusting entries on October 31 to record accrued interest. c. Prepare the Current Liability section of Red Bank?s balance sheet as of October 31. Assume that the Accounts Payable account totals $203,600 on this date.
Question 4
Research an article on a current event that centers on a controversial issue where the two sides are claiming opposing views. Then describe how you would analyze the situation to settle the issue if you were involved in this event. For example, if the article was about whether a proposed new law about gun control will reduce deaths, you may describe how you would use hypothesis testing to compare data from states where such laws exist. Or if the article was about actions to take to reduce gas prices, you could talk about how you would use regression to figure out which factors affected prices at the pump the most. Please note that this discussion should be limited to how statistical analysis can be applied to current issues. This is not the place to champion a particular position on the issue you are discussing, or get into an argument about the various sides of an issue. Remember, you are here to analyze, not proselytize. Please use the template below in your answers, so everyone can easily follow your answers to all the questions (copy and paste to your post). Use this template for your Unit 6 Discussion Summary of the article Briefly describe the current event described in the article. Central question What issue or question you will be focusing on in your analysis? What are the conflicting points of view? There has to be some specific issue in dispute at the center (Do tax breaks increase spending? What impacts healthcare costs the most? And so on.), and the sides have to be defending a particular position. Do not use examples where the issue is based on opinions or morality. For example, ?Should abortion be legal?? is largely a morality question and is not suitable for statistical analysis. Conducting a survey to ask people about their opinions is not the same as analyzing data and making conclusions. Methodology Explain which methodology you will apply. Provide the relevant details. Where will your data come from? How will the results from this methodology answer the question you described above? For example, if you are going to use forecasting, explain how you will do that and how you will measure your accuracy. How will the forecast settle the issue? If you will do a regression analysis, explain what the dependent and independent variables will be. If you will do hypothesis testing, what will the null and alternative hypothesis be?
Question 5
The following financial statement information is from five separate companies: Company Company Company Company Company A B C D E December 31 , 201 0 Assets . . . . . . . . . . . . . . . . . . . . . . . . . $45,000 $35,000 $29,000 $80,000 $1 23,000 Liabilities . . . . . . . . . . . . . . . . . . . . . . 23,500 22,500 1 4,000 38,000 ? December 31 , 201 1 Assets . . . . . . . . . . . . . . . . . . . . . . . . . 48,000 41 ,000 ? 1 25,000 1 1 2,500 Liabilities . . . . . . . . . . . . . . . . . . . . . . ? 27,500 1 9,000 64,000 75,000 During year 201 1 Stock issuances . . . . . . . . . . . . . . . . . 5,000 1 ,500 7,750 ? 4,500 Net income (loss) . . . . . . . . . . . . . . . 7,500 ? 9,000 1 2,000 1 8,000 Cash dividends . . . . . . . . . . . . . . . . . 2,500 3,000 3,875 0 9,000 1. Answer the following questions about Company A: a. What is the amount of equity on December 31, 2010? b. What is the amount of equity on December 31, 2011? c. What is the amount of liabilities on December 31, 2011? 2. Answer the following questions about Company B: a. What is the amount of equity on December 31, 2010? b. What is the amount of equity on December 31, 2011? c. What is net income for year 2011? 3. Calculate the amount of assets for Company C on December 31, 2011. 4. Calculate the amount of stock issuances for Company D during year 2011. 5. Calculate the amount of liabilities for Company E on December 31, 2010.,Are you sure of this solution. The answers do not match the text book Check (1 b) $31 ,500 (2c) $2,500 (3) $46,875
