We use cookies to give you the best experience possible. By continuing we’ll assume you’re on board with our cookie policy

Introduction Essay

Mr Tim Budge and his fianc Jennifer Lopez are looking at a handsome house
and land package, But to do this they have to discuss finance with there
local financier. They need to borrow a large sum of money from the bank to
pay for the house.

There weekly income is $1050.00 there weekly outgoing is $450.00 also
whilst keeping in mind they cannot pay back more than 85% that they earn
that month.

Using this table they will find a plan which best suits them.

We will write a custom essay on Introduction specifically for you
for only $16.38 $13.9/page

Order now


Results and Data
Throughout the duration of completing my Excel spreadsheet I found the
following information.


Table 1
|Financial| |
|Details | |
|Weekly Income |$1,050.0|
| |0 |
|Weekly |$450.00 |
|Outgoing| |
|Bank Balance |$15,000.|
| |00|
|Monthly Income|$4,550.0|
| |0 |
|Monthly |$1,950.0|
|Outgoing|0 |
|Max Repayment |$2,210.0|
| |0 |
This is the Couples Financial details. The financier has to take this
information into example when finding a repayment plan best for the couple.


Table 2
|Interest |Present Value |
|Rate| |
|6% |$308,473.51|
|9% |$245,630.35|
|12%|$200,710.91|
|15%|$167,832.43|
|18%|$143,198.57|
I got this information by using the PV (present Value) with the ABS
(absolute) to help retrieve the right answer. The PV formula is PV (rate,
nper, pmt) the rate is interest rate nper is the number of repayments and
pmt is a payment made monthly.


pic
Questions
1.$286568.3693 / =ABS(PV(9%/12,12*20,2578.33))
2.$225150.7822 / =ABS(PV(9%/12,12*20,2025.83))
3.Celeron 2.2 GHz CPU
256 MBs of Ram
LCD TFT 15″ monitor
Optical Mouse
4.Microsoft Excel 2002
Microsoft Word 2002
Operating system Windows XP Professional 2002
5.PV function
ABS function
Merging Cells
Sum formula
Number Sequences
Conclusion
In conclusion I think this spreadsheet would come in very useful to people
wanting to find a repayment plan which best suits them. Which h is very
important in the repaying of the loan.

Choose Type of service

Choose writer quality

Page count

1 page 275 words

Deadline

Order Essay Writing

$13.9 Order Now
icon Get your custom essay sample
icon
Sara from Artscolumbia

Hi there, would you like to get such an essay? How about receiving a customized one?
Check it out goo.gl/Crty7Tt

Introduction Essay
Artscolumbia
Artscolumbia
Mr Tim Budge and his fianc Jennifer Lopez are looking at a handsome house
and land package, But to do this they have to discuss finance with there
local financier. They need to borrow a large sum of money from the bank to
pay for the house.There weekly income is $1050.00 there weekly outgoing is $450.00 also
whilst keeping in mind they cannot pay back more than 85% that they earn
that month.Using this table they will find a plan which best suits them.
Re
2018-12-27 03:00:29
Introduction Essay
$ 13.900 2018-12-31
artscolumbia.org
In stock
Rated 5/5 based on 1 customer reviews