I now have $23,000 in the bank earning interest of .50% per month. I need $33,000 to make a down payment on a house. I can save
an additional $100 per month. How long will it take me to accumulate the $33,000?
1 answer:
Answer:
41.92 months
Explanation:
In this question, we use the NPER formula which is shown in the spreadsheet.
The NPER represents the time period.
Given that,
Present value = $23,000
Future value = $33,000
Rate of interest = 0.50%
PMT = $100
The formula is shown below:
= NPER(Rate;-PMT;-PV;FV;type)
The present value and the PMT comes in negative
So, after solving this, the answer would be 41.92 months
You might be interested in
Answer:
The answer is well illustrated as below
Explanation:
Remember: Five factors affects the Pension Liability and Plan assets.
1 & 2. Expenses which includes service cost and interest cost
The increase in expense always increases the pension liability so the entry would be:
Dr Service cost $27,100
Dr Interest Cost $30,300 ...... $303,000 Opening Pension Liability * 10%
Cr Pension Liability $57,400
3. Actual return increases the Plan Asset
The Actual return on investment received would increase the Assets worth, which means the journal entry must be passed which would increase the Investment Value (Plan Asset). So the entry would be:
Dr Plan Asset $25,700
Cr Actual return $25,700
4. Contributions made increases the Plan Asset because it is an increase in the investment.
So the journal entry would be:
Dr Plan Asset $20,000
Cr Cash Asset $20,000
5. The benefits paid to employees are decrease in both pension asset and the pension liability. (We had actually borrowed money from the employees and had invested that money so paying off the benefits actually decreases the pension liability and assets).
So the double entry would be:
Dr Pension Liability $17,700
Cr Pension Assets $17,700
Kindly input the above values in the following worksheet:
