Value Corp (ABC) is considering leasing an asset from Tintin Corp (XYZ). Here are the relevant facts: Asset Cost is $1,000,000 Depreciation schedule Year 1 20% year 2 32% Year 3 19.20% Year 4 11.52% Year 5 11.52% Year 6 5.76% Lease term 6 years Lease payment $200,000 per year, from time 0 to 5 Asset residual value 30,000 Tax rates Value Corp 5% Tintin Corp 40% Value Corps interest costs are 10% and Tintins are 7%. a. Should Value Corp lease or purchase the asset (Answer this question with IRR and NAL)? b. Should Tinin Corp purchase the Asset and Lease it to Value Corp (Answer this question with IRR and NAL)?? c. What is the maximum lease payment Value Corp will agree to pay? d. What is the minimum lease payment the Tintin will accept as lease payment? e. Will a leasing arrangement be reached between the lessee and lessor? Explain

CAN THE CAUCLATIONS BE DONE IN EXCELL WITH THE WORK SHOW AS I GET TRIPPED UP WITH THAT PART THANK YOU.