Enter a formula using pv in cell b6 to calculate the present value needed for this pension fund. cell b3 is the expected annual interest rate. cell b4 is the total number of monthly payments that will be made. cell b2 is the amount of each monthly payment. payments will be made at the beginning of every period. remember to express the pmt argument as a negative.

Who is not spending wisely? erika goes shopping and saves her receipts. she totals how much she spent and writes it down. mia needs to buy a new pair of shoes because she joined the soccer team. she looks at newspaper ads to find the best price. lauren has been thinking about getting a puppy for a long time. she walks by the pet store at the mall and decides to get a puppy. erin makes a purchase online using a credit card. she knows that she can pay the entire bill when it arrives.

Variable rate cd’s = $90 treasury bills = $150 discount loans = $20 treasury notes = $100 fixed rate cds = $160 money market deposit accts. = $140 savings deposits = $90 fed funds borrowing = $40 variable rate mortgage loans $140 demand deposits = $40 primary reserves = $50 fixed rate loans = $210 fed funds lending = $50 equity capital = $120 a. develop a balance sheet from the above data. be sure to divide your balance sheet into rate-sensitive assets and liabilities as we did in class and in the examples. b. perform a standard gap analysis and a duration analysis using the above data if you have a 1.15% decrease in interest rates and an average duration of assets of 5.4 years and an average duration of liabilities of 3.8 years. c. indicate if this bank will remain solvent after the valuation changes. if so, indicate the new level of equity capital after the valuation changes. if not, indicate the amount of the shortage in equity capital.

Identify whether the statements are true or false by dragging and dropping the appropriate term into the bin provided. long-run economic growth is unlikely to be sustainable because of finite natural resources. in the modern economy, countries that possess few domestic natural resources essentially have no chance to develop economically. finding alternatives to natural resources will be very important to long-term economic growth. in the modern economy, human and physical capital are generally less important in productivity than natural resources. in the 19th century, countries with the highest per capita gdp were nearly always abundant in minerals and productive farming land.