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 annual interest rate of 5 percent. (Round time value factor to 3 decimal places and final answer to 2 decimal places.)

Future value

$

c.	The present value of a savings account that will earn 3 percent annual interest and be worth $2,000 at the end of four years. (Round time value factor to 3 decimal places and final answer to the nearest whole dollar.)

Present value

$ 1770.00

Expert Solution

jeff jeffy answered 1 year ago

Please solve A, B, and C. Please use excel. Please show work. Thank you. A. Use...

Please solve A, B, and C. Please use excel. Please show work. Thank you. A. Use the stocks of Apple, SAP, IBM, Oracle, and Amazon Download the historical data of weekly stock prices and S&P 500 index prices from year 2017-2019 on the website of yahoo finance and save it on an excel file. B. Use a different sheet to save the market adjusted prices of Apple, SAP, IBM, Oracle, and Amazon t and the index. For each stock, compute...

Please Use Excel to Show All Work, I will like your answer :) 15.54 The Tire...

Please Use Excel to Show All Work, I will like your answer :) 15.54 The Tire Rack, America’s leading online distributor of tires and wheels, conducts extensive testing to provide customers with products that are right for their vehicle, driving style, and driving conditions. In addition, the Tire Rack maintains an independent consumer survey to help drivers help each other by sharing their long-term tire experiences. The following data show survey ratings (1 to 10 scale with 10 the highest...

PLEASE SHOW ALL WORK IN EXCEL. Use Bilingual sheet to answer this question. A national survey...

PLEASE SHOW ALL WORK IN EXCEL. Use Bilingual sheet to answer this question. A national survey of companies included a question that asked whether the company had at least one bilingual telephone operator. The sample results of 90 companies follow (Y denotes that the company does have at least one bilingual operator; N denotes that it does not). N N N N Y N Y N N Y N N N Y Y N N N N N Y N...

Please answer in excel only. How do I create the graphs in excel and show the...

Please answer in excel only. How do I create the graphs in excel and show the data. Discuss the following two cost functions: TC=20+4Q TC=20+2Q+0.5Q^2 a) Calculate all cost curves and plot these curves on graphs. Total Cost Total Fixed Cost Total Variable Cost Average Total Cost Average Fixed Cost Average Variable Cost Marginal Cost b) In each case, indicate the point at which diminishing returns occur. (For question a), compute the required costs and plot the curves for quantities...

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

Please answer the problem below for all parts. Please show all work and write clearly. Thanks....

Please answer the problem below for all parts. Please show all work and write clearly. Thanks. (Apply total probability and Bayes’ rules) A large industrial firm uses three local motels to provide overnight accommodations for its clients. From past experience it is known that 22% of the clients are assigned rooms at the Ramada Inn, 50% at the Sheraton, and 28% at the Lakeview Motor Lodge. If the plumbing is faulty in 5% of the rooms at the Ramada Inn,...

Please show work.......thanks! Fixed Income HW due 6/29/19 Assume today is June 19, 2019 and that...

Please show work.......thanks! Fixed Income HW due 6/29/19 Assume today is June 19, 2019 and that all bonds pay interest annually with a face value of $1,000. YTM = Current yield + Capital Gains yield; CY = Annual Interest/Current Price GE is A rated; AA Treasuries yield 3-year is 1.90%, 10-year 2.10% 5 Years ago GE issued 6% coupon paying bonds with a face value set to mature on June 19, 2029. Growth concerns have forced monetary authorities throughout the...

Please read clearly and answer with explanation Thanks! B ) Show how each of the following...

Please read clearly and answer with explanation Thanks! B ) Show how each of the following would affect the U.S. balance of payments. Include a description of the debit and credit items, and in each case identify which specific account is affected (e.g., imports of goods and services, IM; exports of assets, EXA; and so on). a). The U.S. central bank purchases $500 million worth of U.S. Treasury bonds from a British financial firm and sells pound sterling foreign reserves.

Please use excel and show all work and formulas. (I will give your work a like...

Please use excel and show all work and formulas. (I will give your work a like if you do this) Size (1000s sq. ft) Selling Price ($1000s) 1.26 117.5 3.02 299.9 1.99 139.0 0.91 45.6 1.87 129.9 2.63 274.9 2.60 259.9 2.27 177.0 2.30 175.0 2.08 189.9 1.12 95.0 1.38 82.1 1.80 169.0 1.57 96.5 1.45 114.9 What are the p-values of the t test (for the slope estimate) and F test? What is the coefficient of determination? What is...

Show how to answer this in EXCEL ONLY, NO megastat or minitab, etc.. Please highlight what...

Show how to answer this in EXCEL ONLY, NO megastat or minitab, etc.. Please highlight what data tools or formulas were used. A survey investigated the public’s attitude toward the federal deficit. Each sampled citizen was classified as to whether he or she felt the government should reduce the deficit or increase the deficit, or if the individual had no opinion. The sample results of the study by gender are reported to below. Gender Reduce the Deficit Increase the Deficit...

Question