Purpose of Assignment
The mind of this assignment is to suffer the students to apprehend and exercitation the delineation of offer prize, coming prize, and curiosity-behalf trounce using Microsoft® Excel®.
Resources: Microsoft® Office® 2013 Accessibility Tutorials, Microsoft® Excel®, Span Prize of Capital Calculations Template
Calculate the aftercited span prize of capital problems using Microsoft® Excel®:
If we fix $8,592.00 in a savings representation paying 7.5 percent curiosity-behalf compounded per-annum, how plenteous succeed our representation gain-ground to in 9.5 years?
What is the offer prize of $992 to be ordinary in 13.5 years from today if our allowance trounce is 3.5 percent?
If you bought a hoard for $45 dollars and could hawk it fifteen years succeeding for three spans what you originally paid. What was your render on owning this hoard?
Suppose you bought a lineage for $3,250,000 to construct it a nursing abode in the coming. But you own not committed to the contrivance and succeed run in nine years whether to go eager after a while it or hawk off the lineage. If veritable order prizes extension per-annum at 1.5%, how plenteous can you forecast to hawk the lineage for in nine years if you prefer not to profits after a while the nursing abode contrivance?
If your daughter wants to win $215,000 after a whilein the instant twenty-three years and the salaries expand at 4.45% per year. What compensation should she set-on-foot to extend her aim?