this is accounting excel, having trouble figuring out formula for each question.

Tetu has a manufacturing bulding that they paid 5500,000 on December 31,2022 . To psy for the at the end of each month with cosh. Complete the Mortgage Payment worksheet using the PMY and PPMr functions, You should use each function in only one column on the Mortgage Payment. worksheet. Mint: Don't forget to put a negatwe sien in front of the function. The manufacturing buiding should be depreciated over 15 years using straght in e depreciation. It will befully depreciated (no salvagevake), Please use the SuN function to calculate the annual depriciation in cell 86 on the Depreciation Worksheet: On sanuary 1,2023, the company bought 4 trucks for a total cost of $200,000 from Rivian. The trucks should be deprecsited using double declining batance over a five- year period. At the end of five years, each truck 8 expected to be sold for $10,000. plesse use the ofo function only ONick to calculate the depreciation in each of the five years. Testu is eansidering buying $200,000 of specialized equipment. The purchase would be made December 31,2002 The cormpany would expect to have positive cath flows of $70,000 in 2023, $100,000 in years 2024 and 2025, and $50,000 in 2020. The equipment would not have any rahuge value. The Valve (MPV) functions so the company can decide whether to purchase the equipment, Use the iph and NPV worksheet. Eba Muk is the cro of Tela and pars special atiention to the stock price of Telli, Usine the srocionstony function, create a table showng the closing price of Testa stock for each day during the month of January z023, Use the worksheet provided. Testa s conildering asuhy 10-year bonds wht a face value of 54,000 , The coupen rate is 5W so the bondi wilt pary 5% of the $1,000 faci valie in intereit everr vear, or $30. However, because intereat is pais semiannually in two equal payments, there wili be 20 coupon pirymeats of $25 each. The 51,000 Prospectve bond holders want to know the present value of the bonds. Please use the present value (pv) function to determine this, Use the worksheet provided