Calculate the payment using insert function

Assignment Help Management Theories

Reference no: EM131597057

Question: To complete this assignment, perform the following tasks:

1) Data has been provided for you to generate a payment for each of the two products to help determine which product is feasible for you to purchase for school purposes. Click here to access the data.

2) The loan parameters have been entered into the worksheet. Click in cells B8 and E8 to calculate the amount to finance as Price - down payment - rebate.

3) Calculate the payment on B10 and E10.

Hint: Click Insert function and select PMT for payment.

4) Save the workbook as "FirstInitial_LastName_Purchase_solution.xlsx"

5) Merge and center the titles in Cells A1:E1. Format your worksheet by including color as well as providing an appropriate clip art to accent the document.

6) Indent the content in cells A4:A9 and show the Payment amount in font size 14.

7) Indent the content in cells D4:D9 and show the Payment amount in font size 14.

8) Save the School Computer Purchase Analysis spreadsheet. Close the workbook and then exit Excel.

Reference no: EM131597057

Questions Cloud

Support primary and secondary capital markets : In the equities capital markets, participants play key roles to support primary and secondary capital markets.

Identify the current competitors and industry : Identify the current competitors and industry trends of Merck and Co. that have had the mossy significant impact on the companies financial performance.

Assess for any issues of violence that may be present : Assess for any issues of violence that may be present, and discuss what you would do if there were violence in the home.

Annual dollar annual dollar : What is the annual dollar amount of interest that you receive from your bond investment?

Calculate the payment using insert function : Data has been provided for you to generate a payment for each of the two products to help determine which product is feasible for you to purchase for school.

Assess whether socio-economic strategies can be utilized : Assess whether socio-economic strategies can be utilized to eliminate motivation of terrorist group or if military action is only viable response to terrorists.

Discuss the given disaster plans : Using the South University Online Library or the Internet, research SNS. Based on your understanding, respond to the following.

Targeted capital structure : Wilson Corporation (not real) has a targeted capital structure of 40% long term debt and 60% common stock. The debt is yielding 6% and the corporate tax rate.

Communicable diseases in a city health department : You are the director of communicable diseases in a city health department, responsible for a large urban community. It is early spring in 2003.

User Account

All Pages