PLEASE, PERFORM THE EXERCISE IN EXCEL AND SHOW THE FORMULAS 3.- Andres Rosas wants to know how much he must deposit today, so that in 5 years he will have the amount (FV) of 88,180.00, which he needs to pay for a trip, a) if the account pays 6.125% interest compoundable semiannually; b) if the account pays 7.65% compoundable monthly. The formula must be cleared to find the initial value (PV). Note: In the image, this is the original exercise, it is in Spanish, but it is easy to understand. Very important Note: It is necessary that you make a solution approach and then the result. Above all, to check the procedure and/or the formulas used, especially when you use excel. TO CONSIDER THE YEAR AS 360 DAYS (WHICH IS COMMERCIAL) (only if required)

PLEASE, PERFORM THE EXERCISE IN EXCEL AND SHOW THE FORMULAS 3.- Andres Rosas wants to know how much he must deposit today, so that in 5 years he will have the amount (FV) of 88,180.00, which he needs to pay for a trip, a) if the account pays 6.125% interest compoundable semiannually; b) if the account pays 7.65% compoundable monthly. The formula must be cleared to find the initial value (PV). Note: In the image, this is the original exercise, it is in Spanish, but it is easy to understand. Very important Note: It is necessary that you make a solution approach and then the result. Above all, to check the procedure and/or the formulas used, especially when you use excel. TO CONSIDER THE YEAR AS 360 DAYS (WHICH IS COMMERCIAL) (only if required)

SWFT Corp Partner Estates Trusts

42nd Edition

ISBN:9780357161548

Author:Raabe

Publisher:Raabe

Chapter3: Corporations: Introduction And Operating Rules

Section: Chapter Questions

Problem 55P

See similar textbooks

Similar questions

9 - 391- The balance of the calculated VAT account is 5,000 TL, 191 The balance of the deductible VAT account is also3 750 T, 190-The balance of the transferred VAT account is 1000 TL. Which account is the difference and how?saved? A) 360-To the receivable of the tax and funds account payable B) 190- To the debt of the transferred VAT accountC) 360-To the debt of the tax and funds payable account D) 190- To the receivable of the VAT account of the transferredE) None
Zeeb LLC has 12% perpetual debt of OMR 120,000. The tax rate is 50%. Calculate Kd? a. 10% b. 6% c. 12% d. 5%
13. In 2022, Mr. Sun Ho was charged interest expense on a business related loan in the amount of PHP 60,000. His interest income on bank account with BPI is PHP 720. How much is the deductible interest expense? a. None b. PHP 59,856 c. PHP 144 d. PHP 60,000
businessman invested P1,000.00 and after 4 years, it becomes P1,608.44 when he investedat a certain rate of interest compounded bi-monthly. Determine the nominal rate and thecorresponding effective rate.
Compute for the simple interest earned given the principal P, interest rate r and time t. a) P = 10,000 pesos; r = 5%; t = 3 b) P = 100,000 pesos; r = 20%; t = 7 months c) P = 25,000 pesos; r = 12.5%; t = 165 days (ordinary interest)
21- After our business deducted 20% income tax on 48.000 TL, which is the one-year rent of the workplace it rented for one year on 01.03.2020 , the rest was paid to the owner of the real estate from the bank. In accordance with the concept of periodicity, how much is the amount that should be accepted as an expense in the future period? a) 40.000 TL B) 8.000 TL NS) 9,600 TL D) 38,400 TL TO) 48,000 TL
3.- WHAT INTEREST WILL PRODUCE A CAPITAL OF $25,000 AT 16.169% SEMI-ANNUAL IN 4 YEARSA) S 60323.8B) $62,000C) OTHERD) $60525.5
19 - What is the total interest / dividend amount to be repaid at the end of 6 years for the loan of 160 000 lira withdrawn from the bank for housing needs with an annual 15% simple interest?A) 305 000B) 305 500C) 303 000D) 304 000E) 306 000
The Flatiron Group, a private equity firm headquartered in Boulder, Colorado, borrows £5,000,000 for one year at 7.375% interest (assume annual compounding). What is the dollar cost of this debt if the pound depreciates from $2.0625/£ to $1.9460/£ over the year? Please enter your answer as % -- e.g. if your answer is 2.34% type in 2.34.
If $800,000 of 11% bonds are issued at 102 3/4, the amount of cash received from the sale is O a. $800,000 O b. $888,000 Oc. $822,000 O d. $600,000
D3) Company Z borrows EUR 1 million from the Bank at an annual interest rate of 3,5% for one year. The corporate tax that company Z is paying ia of 50%.Calculate the Tax shield.
E Co. has incurred $10,000 in costs to issue bonds. The costs are fees paid to a transfer agent, commission on the sale of bonds, and other related fees and expenses. How should these costs be deducted for tax purposes? Question 10 options: Deduct $10,000 over a two-year period, claiming $5,000 per year. Deduct $10,000 over a five-year period, claiming $2,000 per year. Claim $10,000 once all the bonds are sold. Claim $10,000 as an expense once the bonds mature. B Co. plans to raise $200,000 for an expansion project through fixed dividend preferred shares at 9%. B's tax rate is 27%. How much corporate income will B require to service the cost of the expansion? Question 7 options: $0 $18,000 $24,658 $4,860