Each student must develop a retirement budget in Microsoft Excel. It must contain budgeting of defined contributions, taxable investment account and social security benefits. Upload Excel file to the Project Assignment in Blackboard.
The following is a list of items required for the budget project. You must also refer to the basic layout and calculations reviewed in class.
List
Contribution, investment and distribution of a Traditional 401k Account, Roth IRA Account and Taxable Investment Account.
Receipt of social security payments in retirement.
Income from salary and/or other taxable income, including from taxable investments.
Deductions and taxes.
General expenses like mortgage/rent (payment must be calculated), transportation, food, student loan payments, etc...
Include the effect of inflation on income and expenses
Track retirement account balances.
Budget should begin 2021 and end in year of life expectancy.
I expect to see changes to income and expenses after retirement.
All contribution, investment and distribution rules and limits will be graded for accuracy.

After the 2008 recession, the amount of reserves in the us banking system increased. because of federal reserve actions, required reserves increased from $44 billion to $60 billion. however, banks started holding more reserves than required. by january 2009, banks were holding $900 billion in excess reserves. the federal reserve started paying interest on the excess reserves that the banks held. what possible impact will these unused reserves have on the economy?

Kiona co. set up a petty cash fund for payments of small amounts. the following transactions involving the petty cash fund occurred in may (the last month of the company's fiscal year). may 1 prepared a company check for $350 to establish the petty cash fund. 15 prepared a company check to replenish the fund for the following expenditures made since may 1. a. paid $109.20 for janitorial services. b. paid $89.15 for miscellaneous expenses. c. paid postage expenses of $60.90. d. paid $80.01 to the county gazette (the local newspaper) for an advertisement. e. counted $26.84 remaining in the petty cashbox. 16 prepared a company check for $200 to increase the fund to $550. 31 the petty cashier reports that $380.27 cash remains in the fund. a company check is drawn to replenish the fund for the following expenditures made since may 15. f. paid postage expenses of $59.10. g. reimbursed the office manager for business mileage, $47.05. h. paid $48.58 to deliver merchandise to a customer, terms fob destination. 31 the company decides that the may 16 increase in the fund was too large. it reduces the fund by $50, leaving a total of $500.

Parks corporation is considering an investment proposal in which a working capital investment of $10,000 would be required. the investment would provide cash inflows of $2,000 per year for six years. the working capital would be released for use elsewhere when the project is completed. if the company's discount rate is 10%, the investment's net present value is closest to (ignore income taxes) ?