1 Sheridan Design Inc. (SD) is a privately owned business that provides interior decorating options for consumers. SD follows ASPE The software that it purchased six years ago to present clients with designs that are unique to their offices is no longer state of the art, and SD has to make a decision on replacing its software. The company has two options: Enter into a lease agreement with Precision Inc. whereby SD makes an upfront lease payment of $12.090 on January 1. 2021, and annual payments of $4,340 over the next five years on each December 31. At the end of the lease. SD has the option to buy the software for $4,895. The first annual lease payment is on December 31, 2021. 2 Enter into a lease agreement with Graphic Inc. on January 1, 2021. whereby SD makes five annual lease payments of $6,585, beginning on January 1, 2021. SD may purchase the software at the end of the lease period for $204. This is considered a bargain price compared with the offer of $4,895 in the proposal from Precision Inc. Under both options, the software will require annual upgrades that are expected to cost $1.552 per year. These upgrade costs are in addition to the lease payments that are required under the two independent options. Because this additional cost is the same under both options, SD has decided to ignore it in making its choice The Precision agreement requires a licensing fee of 51.038 to be renewed annually. If SD decides on the Precision option, the licensing fee will be included in the annual lease payment of $4 340. Both Precision inc. and Graphic inc offer software programs of similar cuality and ease of use, and both provide adequate support and training. The software under each offer is expected to be used for up to eight years, although this depends to some extent on technological advances in future years. Both offers are cuivalent in terms of the product and service It is now early October 2020. and SD hopes to have the software in place by its fiscal year end of December 31, 2020. SD is currently working on preparing its third quarter financial statements, which its bank is particularly interested in seeing in order to ensure that SD is respecting its debt to equity ratio covenant in its loan agreement with the bank. The interest rate on the bank loan, which is SD's only source of external financing, is 10% per year. So would have preferred to be able to buy rather than lease the software, but the expected purchase price of $30,059 exceeds the limits that the bank set for SD's borrowing, Click here to view the factor table PRESENT VALUE OF AN ANNUITY DUE, Part 1 Using tables, a financial calculator, or Excel functions.calculate the PV of the future minimum lease payments under each option (Round foctor values to 5 decimal places, eg. 1.25124 and final answers to decimal places, eg, 5.275) Present Value Option 1 - Precision inc. 5 Option 2 - Graphic inc $ Option 2 - Graphic Inc Determine the nature of the lease arrangement under each of the two lease options offered to SD and the corresponding accounting treatment that should be applied. The accounting treatment of the lease Option 1 - Precision Inc. Option 2 - Graphic Inc e Textbook and Media List of Accounts Attempts: 0 of 2 used submit Ammer Prepare all necessary journal entries and adjusting journal entries for SD under the Precision Inc. option from lease inception on January 1, 2021, through to December 31, 2021, excluding the $1,552 annual upgrade. (Credit account titles are automatically Indented when the amount is entered. Do not indent manually. If no entry is required, select "No Entry for the account titles and entero for the amounts.) Date Account Titles and Explanation Debit Credit Jan 1. 2021 Dec 31, 2021 To record payment of rent and operating expenses. Dec 31, 2021 Prepare an amortization schedule using Excel that would be suitable for the lease term in the Graphic Inc. option (Round answers to decimal places, s. 5,275) Annual Lease Payment Sheridan Design Inc. Lease Amortization Schedule with Graphic Inc. Interest Reduction on Unpaid of Lease Obligation Obligation Date Balanc of Lea: Obligat 1121 1121 $ s 1/1/22 1123 1124 1/125 11:26 Prepare all necessary journal entries and adjusting journal entries for SD under Graphic's option from lease inception on January 1, 2021, through to January 1, 2022, excluding the $1.552 annual upgrade. (Round answers to decimal places, eg. 5,275, Credit account titles are automatically indented when the amount is entered. Do not indent manually. If no entry is required, select "No Entry for the account titles and enter for the amounts.) Date Account Titles and Explanation bit Credit Jan 1.2021 (To record inception of lease and histlease payment To record interest To record interest.) (To record depreciation expense) To record lease payment.) Summarize and contrast the effects on SD's financial statements for the year ending December 31, 2021. using the entries prepared in parts (b) and (d) above. Include in your summary the total differential cash outflows that would be made by SD during 2021 under each option (If the cash flow is negative, please enter negative amounts using either a negative sin preceding the number eg. 45 or parentheses es (451) Option No. 1 Income statement effects Option No. 2 Operating Lease Capital Lease $ - $ Asset and liability balances Dec 31, 2021 5 Asset and liability balances Dec 31, 2021 $ $ Total cash inflows / Coutflows) during 2021 s $ e Textbook and Media Option 2 - Graphic Inc Determine the nature of the lease arrangement under each of the two lease options offered to SD and the corresponding accounting treatment that should be applied. The accounting treatment of the lease Option 1 - Precision Inc. Option 2 - Graphic Inc e Textbook and Media List of Accounts Attempts: 0 of 2 used submit Ammer Part 4 Prepare all necessary journal entries and adjusting journal entries for SD under Graphic's option, from lease inception on January 1, 2021, through to January 1, 2022. ocluding the $1,552 annual upgrade. (Round answers to decimal places, eg. 5,275. Credit account titles are automatically Indented when the amount is entered. Do not indent manually. If no entry is required, select "No Entry" for the account titles and enter for the amounts.) Date Account Titles and Explanation Debit Credil Jan 1, 2021 1 (To record inception of lease and first lease payment.) To record interest.) (To record depreciation expense To record lease payment $ $ v $ Total cash inflows/loutflows) during 2021 s $ Part 3 Prepare an amortization schedule using Excel that would be suitable for the lease term in the Graphic Inc. option. (Round answers to decimal places, es, 5.275) Sheridan Design In Lease Amortization Schedule with Graphic Inc. Annual Interest Reduction Balanc Lease on Unpaid of Lease of Leat Date Payment Obligation Obligation Obligat 1/1/21 $ 1/1/21 $ 1/1/22 11/23 1/1/24 1/1/25 I 11:26 5 $ Part 2 Prepare all necessary journal entries and adjusting journal entries for SD under the Precision Inc option from lease inception on January 1, 2021, through to December 31, 2021, excluding the $1.552 annual upgrade. (Credit account titles are automatically indented when the amount is entered. Do not indent manually. If no entry is required, select "No Entry for the account titles and enter 0 for the amounts) Date Account Titles and Explanation Debit Credit Jan. 1, 2021 Dec. 31, 2021 (To record payment of rent and operating expenses. Dec. 31 2021 To record expired rent) Part 5 Summarize and contrast the effects on SD's financial statements for the year ending December 31, 2021, using the entries prepared in parts (b) and (d) above. Include in your summary the total differential cash outflows that would be made by SD during 2021 under each option. If the cash flow is negative, please enter negative amounts using either a negative sign preceding the numberes. 45 or parentheseses (454 Income statement effects Option No. 1 Operating Lease Option No. 2 Capital Lease $ $ Asset and liability balances Dec 31, 2021 s Sheridan Design Inc. (SD) is a privately owned business that provides interior decorating options for consumers. SD follows ASPE The software that it purchased six years ago to present clients with designs that are unique to their offices is no longer state of the art, and SD has to make a decision on replacing its software. The company has two options 1. 2 Enter into a lease agreement with Precision Inc. whereby SD makes an upfront lease payment of $12.090 on January 1. 2021, and annual payments of $4,340 over the next five years on cach December 31. At the end of the lease, SD has the option to buy the software for $4.895. The first annual lease payment is on December 31, 2021. Enter into a lease agreement with Graphic Inc. on January 1, 2021. whereby SD makes five annual lease payments of $6,585, beginning on January 1, 2021. SD may purchase the software at the end of the lease period for $204. This is considered a bargain price compared with the offer of S4 895 in the proposal from Precision Inc. Under both options, the software will require annual upgrades that are expected to cost $1.552 per year. These upgrade costs are in addition to the lease payments that are required under the two independent options. Because this additional cost is the same under both options, SD has deqided to ignore it in making its choice The Precision agreement requires a licensing fee of $1.038 to be renewed annually, if SD decides on the Precision option, the licensing fee will be included in the annual lease payment of $4.340. Both Precision Inc. and Graphic Inc. offer software programs of similar quality and ease of use, and both provide adequate support and training. The software under each offer is expected to be used for up to eight years, although this depends to some extent on technological advances in future years. Both offers are equivalent in terms of the product and service. It is now early October 2020, and SD hopes to have the software in place by its fiscal year end of December 31, 2020. SD is currently working on preparing its third-quarter financial statements, which its bank is particularly interested in seeing in order to ensure that SD is respecting its debt to equity ratio covenant in its loan agreement with the bank. The interest rate on the bank loan, which is SD's only source of external financing, is 10% per year. SD would have preferred to be able to buy rather than lease the software, but the expected purchase price of $30.059 exceeds the limits that the bank set for SD's borrowing Click here to view the factor table PRESENT VALUE OF AN ANNUITY DUE 1 Sheridan Design Inc. (SD) is a privately owned business that provides interior decorating options for consumers. SD follows ASPE The software that it purchased six years ago to present clients with designs that are unique to their offices is no longer state of the art, and SD has to make a decision on replacing its software. The company has two options: Enter into a lease agreement with Precision Inc. whereby SD makes an upfront lease payment of $12.090 on January 1. 2021, and annual payments of $4,340 over the next five years on each December 31. At the end of the lease. SD has the option to buy the software for $4,895. The first annual lease payment is on December 31, 2021. 2 Enter into a lease agreement with Graphic Inc. on January 1, 2021. whereby SD makes five annual lease payments of $6,585, beginning on January 1, 2021. SD may purchase the software at the end of the lease period for $204. This is considered a bargain price compared with the offer of $4,895 in the proposal from Precision Inc. Under both options, the software will require annual upgrades that are expected to cost $1.552 per year. These upgrade costs are in addition to the lease payments that are required under the two independent options. Because this additional cost is the same under both options, SD has decided to ignore it in making its choice The Precision agreement requires a licensing fee of 51.038 to be renewed annually. If SD decides on the Precision option, the licensing fee will be included in the annual lease payment of $4 340. Both Precision inc. and Graphic inc offer software programs of similar cuality and ease of use, and both provide adequate support and training. The software under each offer is expected to be used for up to eight years, although this depends to some extent on technological advances in future years. Both offers are cuivalent in terms of the product and service It is now early October 2020. and SD hopes to have the software in place by its fiscal year end of December 31, 2020. SD is currently working on preparing its third quarter financial statements, which its bank is particularly interested in seeing in order to ensure that SD is respecting its debt to equity ratio covenant in its loan agreement with the bank. The interest rate on the bank loan, which is SD's only source of external financing, is 10% per year. So would have preferred to be able to buy rather than lease the software, but the expected purchase price of $30,059 exceeds the limits that the bank set for SD's borrowing, Click here to view the factor table PRESENT VALUE OF AN ANNUITY DUE, Part 1 Using tables, a financial calculator, or Excel functions.calculate the PV of the future minimum lease payments under each option (Round foctor values to 5 decimal places, eg. 1.25124 and final answers to decimal places, eg, 5.275) Present Value Option 1 - Precision inc. 5 Option 2 - Graphic inc $ Option 2 - Graphic Inc Determine the nature of the lease arrangement under each of the two lease options offered to SD and the corresponding accounting treatment that should be applied. The accounting treatment of the lease Option 1 - Precision Inc. Option 2 - Graphic Inc e Textbook and Media List of Accounts Attempts: 0 of 2 used submit Ammer Prepare all necessary journal entries and adjusting journal entries for SD under the Precision Inc. option from lease inception on January 1, 2021, through to December 31, 2021, excluding the $1,552 annual upgrade. (Credit account titles are automatically Indented when the amount is entered. Do not indent manually. If no entry is required, select "No Entry for the account titles and entero for the amounts.) Date Account Titles and Explanation Debit Credit Jan 1. 2021 Dec 31, 2021 To record payment of rent and operating expenses. Dec 31, 2021 Prepare an amortization schedule using Excel that would be suitable for the lease term in the Graphic Inc. option (Round answers to decimal places, s. 5,275) Annual Lease Payment Sheridan Design Inc. Lease Amortization Schedule with Graphic Inc. Interest Reduction on Unpaid of Lease Obligation Obligation Date Balanc of Lea: Obligat 1121 1121 $ s 1/1/22 1123 1124 1/125 11:26 Prepare all necessary journal entries and adjusting journal entries for SD under Graphic's option from lease inception on January 1, 2021, through to January 1, 2022, excluding the $1.552 annual upgrade. (Round answers to decimal places, eg. 5,275, Credit account titles are automatically indented when the amount is entered. Do not indent manually. If no entry is required, select "No Entry for the account titles and enter for the amounts.) Date Account Titles and Explanation bit Credit Jan 1.2021 (To record inception of lease and histlease payment To record interest To record interest.) (To record depreciation expense) To record lease payment.) Summarize and contrast the effects on SD's financial statements for the year ending December 31, 2021. using the entries prepared in parts (b) and (d) above. Include in your summary the total differential cash outflows that would be made by SD during 2021 under each option (If the cash flow is negative, please enter negative amounts using either a negative sin preceding the number eg. 45 or parentheses es (451) Option No. 1 Income statement effects Option No. 2 Operating Lease Capital Lease $ - $ Asset and liability balances Dec 31, 2021 5 Asset and liability balances Dec 31, 2021 $ $ Total cash inflows / Coutflows) during 2021 s $ e Textbook and Media Option 2 - Graphic Inc Determine the nature of the lease arrangement under each of the two lease options offered to SD and the corresponding accounting treatment that should be applied. The accounting treatment of the lease Option 1 - Precision Inc. Option 2 - Graphic Inc e Textbook and Media List of Accounts Attempts: 0 of 2 used submit Ammer Part 4 Prepare all necessary journal entries and adjusting journal entries for SD under Graphic's option, from lease inception on January 1, 2021, through to January 1, 2022. ocluding the $1,552 annual upgrade. (Round answers to decimal places, eg. 5,275. Credit account titles are automatically Indented when the amount is entered. Do not indent manually. If no entry is required, select "No Entry" for the account titles and enter for the amounts.) Date Account Titles and Explanation Debit Credil Jan 1, 2021 1 (To record inception of lease and first lease payment.) To record interest.) (To record depreciation expense To record lease payment $ $ v $ Total cash inflows/loutflows) during 2021 s $ Part 3 Prepare an amortization schedule using Excel that would be suitable for the lease term in the Graphic Inc. option. (Round answers to decimal places, es, 5.275) Sheridan Design In Lease Amortization Schedule with Graphic Inc. Annual Interest Reduction Balanc Lease on Unpaid of Lease of Leat Date Payment Obligation Obligation Obligat 1/1/21 $ 1/1/21 $ 1/1/22 11/23 1/1/24 1/1/25 I 11:26 5 $ Part 2 Prepare all necessary journal entries and adjusting journal entries for SD under the Precision Inc option from lease inception on January 1, 2021, through to December 31, 2021, excluding the $1.552 annual upgrade. (Credit account titles are automatically indented when the amount is entered. Do not indent manually. If no entry is required, select "No Entry for the account titles and enter 0 for the amounts) Date Account Titles and Explanation Debit Credit Jan. 1, 2021 Dec. 31, 2021 (To record payment of rent and operating expenses. Dec. 31 2021 To record expired rent) Part 5 Summarize and contrast the effects on SD's financial statements for the year ending December 31, 2021, using the entries prepared in parts (b) and (d) above. Include in your summary the total differential cash outflows that would be made by SD during 2021 under each option. If the cash flow is negative, please enter negative amounts using either a negative sign preceding the numberes. 45 or parentheseses (454 Income statement effects Option No. 1 Operating Lease Option No. 2 Capital Lease $ $ Asset and liability balances Dec 31, 2021 s Sheridan Design Inc. (SD) is a privately owned business that provides interior decorating options for consumers. SD follows ASPE The software that it purchased six years ago to present clients with designs that are unique to their offices is no longer state of the art, and SD has to make a decision on replacing its software. The company has two options 1. 2 Enter into a lease agreement with Precision Inc. whereby SD makes an upfront lease payment of $12.090 on January 1. 2021, and annual payments of $4,340 over the next five years on cach December 31. At the end of the lease, SD has the option to buy the software for $4.895. The first annual lease payment is on December 31, 2021. Enter into a lease agreement with Graphic Inc. on January 1, 2021. whereby SD makes five annual lease payments of $6,585, beginning on January 1, 2021. SD may purchase the software at the end of the lease period for $204. This is considered a bargain price compared with the offer of S4 895 in the proposal from Precision Inc. Under both options, the software will require annual upgrades that are expected to cost $1.552 per year. These upgrade costs are in addition to the lease payments that are required under the two independent options. Because this additional cost is the same under both options, SD has deqided to ignore it in making its choice The Precision agreement requires a licensing fee of $1.038 to be renewed annually, if SD decides on the Precision option, the licensing fee will be included in the annual lease payment of $4.340. Both Precision Inc. and Graphic Inc. offer software programs of similar quality and ease of use, and both provide adequate support and training. The software under each offer is expected to be used for up to eight years, although this depends to some extent on technological advances in future years. Both offers are equivalent in terms of the product and service. It is now early October 2020, and SD hopes to have the software in place by its fiscal year end of December 31, 2020. SD is currently working on preparing its third-quarter financial statements, which its bank is particularly interested in seeing in order to ensure that SD is respecting its debt to equity ratio covenant in its loan agreement with the bank. The interest rate on the bank loan, which is SD's only source of external financing, is 10% per year. SD would have preferred to be able to buy rather than lease the software, but the expected purchase price of $30.059 exceeds the limits that the bank set for SD's borrowing Click here to view the factor table PRESENT VALUE OF AN ANNUITY DUE