Island News purchased a piece of property for $1.46 million. The firm paid a down payment of 20 percent in cash and financed the balance. The loan terms require monthly payments for 20 years at an APR of 4.33 percent, compounded monthly. What is the amount of each mortgage payment?

Annuity payments are assumed to come at the end of each payment period (termed an ordinary annuity). however, an exception occurs when the annuity payments come at the beginning of each period (termed an annuity due). what is the future value of a 13-year annuity of $2,800 per period where payments come at the beginning of each period? the interest rate is 9 percent. use appendix c for an approximate answer, but calculate your final answer using the formula and financial calculator methods. to find the future value of an annuity due when using the appendix tables, add 1 to n and subtract 1 from the tabular value. for example, to find the future value of a $100 payment at the beginning of each period for five periods at 10 percent, go to appendix c for n = 6 and i = 10 percent. look up the value of 7.716 and subtract 1 from it for an answer of 6.716 or $671.60 ($100 × 6.716)

Excel allows you to take a lot of data and organize it in one document. what are some of the features you can use to clarify, emphasize, and differentiate your data?

Jamie is saving for a trip to europe. she has an existing savings account that earns 3 percent annual interest and has a current balance of $4,200. jamie doesn’t want to use her current savings for vacation, so she decides to borrow the $1,600 she needs for travel expenses. she will repay the loan in exactly one year. the annual interest rate is 6 percent. a. if jamie were to withdraw the $1,600 from her savings account to finance the trip, how much interest would she forgo? .b. if jamie borrows the $1,600 how much will she pay in interest? c. how much does the trip cost her if she borrows rather than dip into her savings?