Please help me with this project. It needs to include formulas and also need to use Excel

ACCT 4130 Excel Project Fall 2017 Dr. Henry Khaleesi Corporation (\"Khaleesi\") leases dragonglass weapons to customers. She gains a loyal following of customers because dragonglass is of limited supply but high demand due to its usefulness for the upcoming winter. Further, Khaleesi tends to offer more favorable financing terms than competitors offering substitutive products (e.g., Lannister, LLC). Khaleesi was recently approached by the Lords of the North, Inc. (\"the North\") which is interested in leasing a substantial stock of weapons over a potentially lengthy period of time. The North has indicated a willingness to pay any rate that Khaleesi Corporation demands for its dragonglass products, but generally receives an interest rate of 12% on all other borrowing transactions. The North's management are a very noble group, so payments are reasonably assured. Further, there are no material cost uncertainties. Khaleesi has gathered its council to discuss entering into such a contract with the North and has invited you to provide financial council. Khaleesi's board has proposed several alternative sets of lease terms (below) and would like you determine what the North's annual payments will be under each scenario, if payments are made at the beginning of the period. Fair value of weapons to be leased A $365,760 B $365,760 C $365,760 D $365,760 Book value of weapons to be leased $365,760 $290,760 $365,760 $365,760 $0 $75,000 $0 $0 Lease Term 11 years 11 years 6 years 6 years Useful Life of leased assets 13 years 13 years 6 years 6 years 10% 10% 10% 13.225% $24,350 $24,350 $25,000 $75,000 Desired Profit on Lease Initiation Desired rate of return Residual Value (guaranteed) REQUIRED: 1. Prepare a schedule for Khaleesi which uses Excel to compute the North's necessary annual payment under each of the scenarios listed in the chart above. The schedule should list for each scenario above the desired present value of lease payments, future value of the leased asset, the lease term, and the interest rate and utilize an Excel formula to compute a payment. Khaleesi is a high paying client of your firm, so the schedule should be extremely organized and professional looking (e,g., include a title, date, description in the top left-hand corner and utilize borders, font effects, etc. in cells to make the worksheet look visually appealing). (Note: You must use only Excel to prepare and present all parts of this table. Do not use a hand-held calculator, and do not use the compound interest tables to solve any part of this problem. Points will be deducted if Excel formulas are not used for each necessary computation.) 2. Prepare a worksheet that determines the type of lease for each party to the transaction. The purpose of this worksheet is to automate the determination of lease type. This worksheet should show: a. The particulars for each lease scenario. b. List each capital lease requirement and indicate whether or not it is met c. Use Excel formulas where meeting a particular criteria requires a calculation or is contingent on one of the lease criteria (e.g., \"if\" statements). The only items that should be hard-keyed in here are the particulars for the lease scenario and the answers to the first two capital lease criteria (ownership transfer, and bargain purchase option) for the lessee/lessor and the answers to the two lessor-only capital lease criteria. For the requirements below, assume Khaleesi Corporation chooses lease option A and enters into an agreement with the North on 1/1/18. The North should return the weapons on 12/31/2028. 3. Prepare a lease amortization schedule describing the pattern of payments and interest over the lease term for both Khaleesi and the North. (Note: You must use only Excel to prepare and present all parts of this table. Do not use a hand-held calculator, and do not use the compound interest tables to solve any part of this problem.) 4. Prepare the appropriate entries for both Khaleesi and the North on 1/1/18. Numbers in journal entries should be linked to the table prepared in number 3 above or computed using Excel formulas. 5. Prepare the appropriate entries for both Khaleesi and the North through 1/1/21. Numbers in journal entries should be linked to the table prepared in number 3 above or computed using Excel formulas. 6. Prepare the appropriate entries for both Khaleesi and the North on 12/31/2028. Assume the weapons returned to Khaleesi have a residual value of $500. DELIVERABLES: This assignment is due by 11:59pm on September 20. This assignment is worth a total of 20 points toward your final grade. Of those 20 points, up to 10 may be earned through the required/proper use of Excel (i.e,. formulas used in every instance where a \"yeso\" determination or computation is required, unless specifically noted in this document) and for the appropriate level of professional style, and 10 points are awarded for obtaining the correct numbers. Upload a copy of your Excel file into the \"Ch 15 project\" folder in Dropbox. Your file should be named according to the following name convention: LastName_FirstName_Ch15_4130FA17 You should also keep a digital copy of your solution in case we need to review it later. . Important: You need to do this problem alone, not with others. Feel free to use your textbook as you wish, but your instructor does not want to tell you whether you have the \"right answer\" or whether it \"looks right\" before you turn it in. Solving this problem will help you learn more about compound interest concepts, accounting for leases, and using Excel. Further, this project will help you practice client service techniques which include the professional presentation/communication of complex information