Question

In: Finance

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   

Solutions

Expert Solution


Related Solutions

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...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT