x 590 utorial 9 Exploring Financial Tools anu calculatetheerter 12% as the desired rate of return. In cell D27, u the desired rate of specifie present value of return specified in cell D26. In cell D28, enter a forrn present value of their 6. In cell D29, use the calculate the 25. nvestment in the restaurant given their initial pay IRR function to calculate the internal rate of retur ified in the range C1 ent value of the payments made to the investors from t idend values pametworksheet, in the range C39:G39, enter a ref Proposal worksheet. In the range C41:G41, calculate the subtracting the dividends from the after-tax profit 28. In the Balance Sheet worksheet, starting wi back to its source and correct it. 29. Save the workbook, and then close it. dividend values paid to the shareholders as speci th cell G17, trace the #R Case Problem 1 Data File needed for this Case Problem: Digital.xlsx Digital Frames Linda Peltz is a videographer and owner of Digital North Carolina, that records and edits videos for businesses, familie Linda wacis te upgrade the company's computer system and is eva equipment or to lease it. She has asked you to complete an Excel w of owning yersus leasing. Complete the following 1. Open the Digital workbook located in the Excel9 Casel fol and then save the workbook as Digital Frames in the location 2. In the Documentation worksheet, enter your name and the c 3. Linda can upgrade the computer system by purchasing equi want to buy a 36-month service contract at the time of the that she would be able to sell the system for $12,000 after her next upgrade. Enter these values in the Buy vs. Lease Under the lease option, Linda will be able to lease the equ the next 36 months. She will also have to pay a $1,000 se purchase. She won't need to buy a service contract becau x 590 utorial 9 Exploring Financial Tools anu calculatetheerter 12% as the desired rate of return. In cell D27, u the desired rate of specifie present value of return specified in cell D26. In cell D28, enter a forrn present value of their 6. In cell D29, use the calculate the 25. nvestment in the restaurant given their initial pay IRR function to calculate the internal rate of retur ified in the range C1 ent value of the payments made to the investors from t idend values pametworksheet, in the range C39:G39, enter a ref Proposal worksheet. In the range C41:G41, calculate the subtracting the dividends from the after-tax profit 28. In the Balance Sheet worksheet, starting wi back to its source and correct it. 29. Save the workbook, and then close it. dividend values paid to the shareholders as speci th cell G17, trace the #R Case Problem 1 Data File needed for this Case Problem: Digital.xlsx Digital Frames Linda Peltz is a videographer and owner of Digital North Carolina, that records and edits videos for businesses, familie Linda wacis te upgrade the company's computer system and is eva equipment or to lease it. She has asked you to complete an Excel w of owning yersus leasing. Complete the following 1. Open the Digital workbook located in the Excel9 Casel fol and then save the workbook as Digital Frames in the location 2. In the Documentation worksheet, enter your name and the c 3. Linda can upgrade the computer system by purchasing equi want to buy a 36-month service contract at the time of the that she would be able to sell the system for $12,000 after her next upgrade. Enter these values in the Buy vs. Lease Under the lease option, Linda will be able to lease the equ the next 36 months. She will also have to pay a $1,000 se purchase. She won't need to buy a service contract becau
