Business, 02.07.2019 01:20 montgomerykarloxc24x
You are an account manager for inland jewelers, a regional company that makes custom class rings for graduating seniors. your supervisor requested a workbook to report on new accounts created on payment plans. the report should provide details on total costs to the student as well as payment information. each ring financed has a base price which can fluctuate based on ring personalization. instructions: for the purpose of grading the project you are required to perform the following tasks: stepinstructionspoints possible1start excel. download and open the file named exploring_e02_grader_h1.xlsx.0.0002 insert a function in cell b2 to display the current date from your system.10.0003with cell b2 selected, set the width of column b to autofit.2.0004insert a lookup function in cell c5 to display the ring cost for the first student.14.0005copy the formula from cell c5 to the range c6: c11.6.0006apply accounting number format to the range c5: c11.3.0007insert an if function in cell e5 to calculate the total due. if the student has chosen to personalize the ring, there is an additional charge of 5% located in cell b21 that must be applied; if not, the student only pays the base price. use appropriate relative and absolute cell references.14.0008copy the formula from cell e5 to the range e6: e11.6.0009apply accounting number format to the range e5: e11.3.00010insert a function in cell g5 to calculate the first student's monthly payment, using appropriate relative and absolute cell references.14.00011copy the formula from cell g5 to the range g6: g11.7.00012apply accounting number format to the range g5: g11.3.00013calculate totals in cells c12, e12, and g12.7.00014apply accounting number format to the cells c12, e12, and g12, if necessary.2.00015set 0.3" left and right margins and ensure the page prints on only one page.5.00016insert a footer with your name on the left side, the sheet name in the center, and the file name on the right side.4.00017save the workbook. close excel. submit the file as directed by your instructor.0.000
Answers: 2
Another question on Business
Business, 22.06.2019 09:50
phillips, inc. had the following financial data for the year ended december 31, 2019. cash $ 41,000 cash equivalents 75,000 long term investments 59,000 total current liabilities 149,000 what is the cash ratio as of december 31, 2019, for phillips, inc.? (round your answer to two decimal places.)
Answers: 3
Business, 22.06.2019 11:50
Christopher kim, cfa, is a banker with batts brothers, an investment banking firm. kim follows the energy industry and has frequent contact with industry executives. kim is contacted by the ceo of a large oil and gas corporation who wants batts brothers to underwrite a secondary offering of the company's stock. the ceo offers kim the opportunity to fly on his private jet to his ranch in texas for an exotic game hunting expedition if kim's firm can complete the underwriting within 90 days. according to cfa institute standards of conduct, kim: a) may accept the offer as long as he discloses the offer to batts brothers.b) may not accept the offer because it is considered lavish entertainment.c) must obtain written consent from batts brothers before accepting the offer.
Answers: 1
Business, 22.06.2019 12:30
In the 1970s, kmart used blue light specials to encourage customers to flock to a particular department having a temporary sale. a spinning blue light activated for approximately 30 seconds, and then an in-store announcement informed shoppers of the special savings in the specific department. over time, loyal kmart shoppers learned to flock to the department with the spinning blue light before any announcement of special savings occurred. if kmart was employing classical conditioning techniques, what role did the spinning blue light play?
Answers: 3
Business, 22.06.2019 23:10
Mr. pines is considering buying a house and renting it to students. the yearly operating costs are $1,900. the house can be sold for $175,000 at the end of 10 years and it is considered 18% to be a suitable annual effective interest rate. if the house costs $100,000 to purchase, how much would you need to charge your tenants each year in rent? (assume a single payment for the years rent at the end of each year)
Answers: 1
You know the right answer?
You are an account manager for inland jewelers, a regional company that makes custom class rings for...
Questions
Physics, 19.02.2021 23:30
Law, 19.02.2021 23:40
Mathematics, 19.02.2021 23:40
Mathematics, 19.02.2021 23:40
History, 19.02.2021 23:40
English, 19.02.2021 23:40
Chemistry, 19.02.2021 23:40
Mathematics, 19.02.2021 23:40
