Entries by Student

write my assignment 9808

Problem 1. Assume you are an analyst evaluating Mesco Company. The following data are available in your financial analysis (unless otherwise indicated, all data are as of December 31, Year 5):Retained Earnings, December 31, Year 4……..$98,000Gross profit margin ratio……………………………….25%Acid-test ratio…………………………………………….…2.5 to 1Noncurrent assets……………………………………….$280,000Days’ sales in inventory………………………….…….45 daysDays’ sales in receivables………………….…………..18 daysShareholders’ equity to total debt…………………4 to 1Sales (all on credit)……………………………………….$920,000Common stock: $15 par value; 10,000 shares issued and outstanding; issued at $21 per shareRequired:Using these data, construct the December 31, Year 5, balance sheet for your analysis. Operating expenses (excluding taxes and cost of goods sold for Year 5) are $180,000. The tax rate is 40 percent. Assume a 360-day year in ratio computations. No cash dividends are paid in either Year 4 or Year 5. Current assets consist of cash, accounts receivable, and inventories.

 

"Not answered?"


Get the Answer

April 10, 2022by

write my assignment 26627

In this project, you will enter in the correct formulas or functions needed to find out the monthly gross income for a computer repair business. To view these instructions while working in Excel, print these instructions or move back and forth between your browser and Excel.1.Follow this link: Computer Business. Save the file onto your computer. Then locate the Excel file (workbook) on your computer and open it. If you experience problems opening the file, then contact technical support at (877) 221-5800, option 2.2.The orange-colored cells on the worksheet indicate places where you will put in the formulas and functions.3.Calculate the total gross pay for each employee. Keep in mind that employees are paid time and a half for all overtime hours. Here is an example formula that demonstrates how you would make such a calculation: (regular hours * hourly rate) + (overtime hours * hourly rate * 1.5) = (b4*d4) + (b4*c4*1.5). These must be formulas and will be entered into the range E11–E14.4.In steps 5, 6, and 7 below, you must include an absolute reference cell in each formula. Imagine while you are completing these steps that there are 150 employees at the company.5.Calculate the total amount each employee must pay in federal taxes in the range F11–F14. These calculations must be completed using formulas. These formulas must contain an absolute reference to the cell holding the percentage amount. The percentage figure used in the formula is above the word federal in cell F9.6.Calculate the total amount each employee must pay in state taxes in the range G11–G14. These calculations must be completed using formulas. These formulas must contain an absolute reference to the cell holding the percentage amount. The percentage figure used in the formula is above the word state in cell G9.7.Calculate the total amount each employee must pay in social security taxes in the range H11–H14. These calculations must be completed using formulas. These formulas must contain an absolute reference to the cell holding the percentage amount. The percentage figure is above the word social in cell H9.8.Calculate the total net pay for each employee in the range I11–I14. These calculations must be completed using a formula.9.Calculate the totals for all of the employee hours and pay categories in the range B16–I16. These calculations must be completed using Sum functions.10.Format all of the cells that represent a dollar amount as currency with 2 decimal places.

 

"Not answered?"


Get the Answer

April 10, 2022by

write my assignment 666

  1. Hypothesis Testing and Confidence Intervals

Consider an idd Sample X1,…,Xn ~ Poiss (lambda) for lambda >0

  • Attachment 1
  • Attachment 2

Consider an i. i.d. Sample $1 . …._In ~ Poiss [A] For ` _ 0 .`Starting from the Central Limit Theorem , find a confidence interval I =*,*& with asymptotic level 1 – & that is centered about * HEINE*the plug – in method .Write bark ni for {n . If applicable , type abs ( x ) for / { | . Philx) for $ ( I) _ PIE = [) where { ~N 10, 1 1 , and qralphal for an , the 1 – 0`quantile of a standard normal variable . !"I = [_A, B| forB –

 

"Not answered?"


Get the Answer

April 10, 2022by

write my assignment 4778

In 1984, a school bus costs $20,000. To answer each of the parts below, assume that the customer price index (CPI) was 36.8 in 1970, 100 in 1984, and 140.7 in 1992.

Part I: If the price of a school bus increased at the same rate as the CPI from 1970 to 1984, how much did a school bus cost in 1970? By how much did the price of a school bus increase from 1979 to 1984?

Part II: If the price of a school bus increased at the aamw rate as the CPI from 1984 to 1992, how much did a school bus cost in 1992? By how much did the price of a school bus increase from 1984 to 1992?

Part III: If a school bus cost $4,100 in 1950, and the price of a school bus increased at the same rate as the CPI from 1950 to 1984, what was the CPI to the nearest tenth in 1950?

 

"Not answered?"


Get the Answer

April 10, 2022by