14. PLEASE SHOW EXCEL WORK THANKS! Based on the following financial data, calculate the ratios requested....

14. PLEASE SHOW EXCEL WORK THANKS!

Based on the following financial data, calculate the ratios requested. (Round your answers to 4 decimal places.)


Liabilities	$	7,800	Net worth	$	58,000
Liquid assets	$	4,600	Current liabilities	$	1,300
Monthly credit payments	$	640	Take-home pay	$	2,575
Monthly savings	$	130	Gross income	$	2,850


a.	Debt ratio
b.	Current ratio
c.	Debt-payments ratio
d.	Savings ratio

Expert Solution

jeff jeffy answered 9 months ago

Please show all work and formulas used. Thanks! The following data are given for an activated...

Please show all work and formulas used. Thanks! The following data are given for an activated sludge process: Q = 5 MGD BOD5 (influent) = 250 mg/L (soluble) BOD5 (effluent) = 20 mg/L (soluble) MCRT = 10 days MLSS in the aeration tank = 2500 mg/L Concentration of SS in the recycle line = 10,000 mg/L Concentration of SS in the effluent = 30 mg/L (70% biodegradable) BOD5/BODu = 0.75, No nutrient limitations. Yield co-efficient, Y = 0.65 Endogenouse decay...

Please show the work in Excel Use the following data to construct a scatter diagram. Does...

***Please show the work in Excel*** Use the following data to construct a scatter diagram. Does there appear to be a relationship between hours of overtime and number of rejects? Discuss. Hours of Overtime Number of Rejects 127 33 90 25 95 23 160 40 10 9 80 19 27 14 103 28 48 19 65 31

Part 1. Financial Ratios Please compute the 6 ratios requested below for the Smith Company as...

Part 1. Financial Ratios Please compute the 6 ratios requested below for the Smith Company as of and for the year ended December 31, 2020. Please refer to Illustration 5A.1 on pages 5-31 and 5-32 of our textbook for a summary of financial ratios and formulas. Compute each ratio to 2 decimal places using excel rounding. The 6 ratios you should compute are: Current ratio Accounts receivable turnover Inventory turnover Profit margin on sales Earnings per share Debt to assets...

19. PLEASE SHOW EXCEL WORK AND ANSWER ONLY B THANKS! Use future value and present value...

19. PLEASE SHOW EXCEL WORK AND ANSWER ONLY B THANKS! Use future value and present value calculations (Use Exhibit 1-A, Exhibit 1-B, Exhibit 1-C) to determine the following: a. The future value of a $600 savings deposit after eight years at an annual interest rate of 6 percent. (Round time value factor to 3 decimal places and final answer to 2 decimal places.) Future value $ 956.40 b. The future value of saving $1,800 a year for five years at an...

PLEASE SHOW WORK IN EXCEL WITH FORMULA You are constructing a two stock portfolio based on...

PLEASE SHOW WORK IN EXCEL WITH FORMULA You are constructing a two stock portfolio based on the information provided below. What dollar amount will you invest in each stock to achieve the desired return goal? Stock X Stock Y Expected Return 14.0% 9.0% Goal Return of Portfolio: 10.00% Dollar Amount to Invest: $20,000

PLEASE SHOW ALL WORK IN EXCEL!!!!!!! SHOW CALCULATIONS / FORMULAS IN EXCEL!!!!!!!! Voters arrive at a...

PLEASE SHOW ALL WORK IN EXCEL!!!!!!! SHOW CALCULATIONS / FORMULAS IN EXCEL!!!!!!!! Voters arrive at a polling station at an average of 4 per minute (Poisson) where the service rate is 50 per hour (Poisson). a. What is the average number of voters in the system with 5 voter booths? (10 pts) b. What is the minimum number of voting booths needed to keep the average time in the system under three minutes? (10 pts) PLEASE SHOW ALL WORK IN...

(PLEASE SHOW WORK) - no financial calculator - no excel 2. David Hoffman purchases a bond...

(PLEASE SHOW WORK) - no financial calculator - no excel 2. David Hoffman purchases a bond with $1,000 principal, 20-year maturity, and 8% coupon (annual payments). Yields on comparable bonds are 10%. Bob expects that two years from now, yields on comparable bonds will have declined to 9%. Find his expected yield, assuming the bond is sold in two years. 3. Calculate the duration of a $1,000, eight-year zero coupon bond using annual compounding and a current market rate of...

Please solve in Excel and show your work. Thank you. Calculate the value of Apples’ stocks...

Please solve in Excel and show your work. Thank you. Calculate the value of Apples’ stocks given These following inputs are from Yahoo finance to see how close the model will match the current mkt price. These are 2019 figures: FCF’s = 60 billion growth= 5% wacc = 7.5% Treasury securities = 51 billion debt = 92 billion #shares= 4.6 billion Assume the growth rate listed is for the first 4 years and then FCF’s will grow at 3.5% thereafter....

Calculate the requested statistics for the following sample data:

Calculate the requested statistics for the following sample data: 11, 13, 5, 13, 7, 8Give the answer to the proper number of decimal places outlined below •..(a) mean =(b) median =(c) mode =(d) range =(e) variance =(f) standard deviation =Rounding Rules:• Mean, Standard Deviation, and Variance: Your answer should be rounded to one more decimal place than the raw data.• Median: If you have to take the mean of two numbers then round that result to one more decimal place than...

Using the data provided in the excel file, show all of your work for the following...

Using the data provided in the excel file, show all of your work for the following calculations: a.) mean temperature of unmixed reagents (oC) b.) δελταT from graph (oC) c.) q absorbed by reaction mixture (J) d.) q absorbed by calorimeter, stirrer, and thermometer (J) e.) q total absorbed (J) f.) q total released (J) g.) calculation to show limiting reagent h.) deltaH neutralization for the reaction (kJ/mole of acid) A student reacted 100.0 mL of 0.9800 M HCl with...

Question