What are value entries in excel

Suppose that jim plans to borrow money for an education at texas a& m university. jim will need to borrow $25,000 at the end of each year for the next five years (total=$125,000). jim wishes his parents could pay for his education but they can’t. at least, he qualifies for government loans with a reduced interest rate while he is in school. he has a special arrangement with aggiebank to lend him the money at a subsidized rate of 1% over five years without having to make a payment until the end of the fifth year. however, at the end of the fifth year, jim agrees to pay off the loan by borrowing from longhorn bank. longhorn bank will lend him the money he needs at an annual interest rate of 6%. jim agrees to pay back the longhorn bank with 20 annual payments and the payments will be uniform (equal annual payments including principal and interest). (i) calculate how much money jim has to borrow at the end of 5 years to pay off the loan with aggiebank. a. $121,336 b. $127,525 c. $125,000 d. $102,020 e. none of the above

Melissa is a very generous single woman. before this year, she had given over $11,400,000 in taxable gifts over the years and has completely exhausted her applicable credit amount. in the current year, melissa gave her daughter riley $100,000 and promptly filed her gift tax return. melissa did not make any other gifts this year. how much gift tax must riley pay the irs because of this transaction?

T-comm makes a variety of products. it is organized in two divisions, north and south. the managers for each division are paid, in part, based on the financial performance of their divisions. the south division normally sells to outside customers but, on occasion, also sells to the north division. when it does, corporate policy states that the price must be cost plus 20 percent to ensure a "fair" return to the selling division. south received an order from north for 300 units. south's planned output for the year had been 1,200 units before north's order. south's capacity is 1,500 units per year. the costs for producing those 1,200 units follow