Instructions

This assignment $($take$-$home quiz$)$ is worth $15$ points and contains $2$ problems.

This is an individual assignment $($no groups$).$ Any signs of cheating will result in a zero score for this assignment and may result in an $F$ grade in the class.

Use Microsoft Excel, and ensure your work is well$-$organized and presented neatly. Messy work will not receive the full mark even if the math is correct.

Print your name$/$student number, save the file as a PDF document or keep it as an Excel, and upload it to eLearning $($scanned copies will not be accepted, you can upload vour spreadsheet work$).$

The deadline for submission is at $11$:$55$ pm on May $24$th$,2024.$ Late submissions will receive a zero score.

According to recent reports, Jordanian households spend an average of $540$ Jordanian dinars on tobacco. This expenditure exceeds what they spend on other essentials like food. The impact of tobacco spending affects both public health and the economy, diverting funds that families need for other necessities.

Source: Jordanian families spend JD $540$ annually on tobacco, second only to meat

Jordanian families spend JD $540$ annually on $|$ Roya News

Problem $1$

If someone initiates smoking at the age of $20,$ consuming $2$ packs daily at $2\mathrm{.}5$ JDS each, totaling $1825$ JDS annually, what would this sum accumulate to by age $60$ with a $6\%$ yearly interest rate? Create a cash flow visualization using Microsoft Excel.

:$.$ Problem $2$

For Problem $1,$ suppose the inflation rate stands at $3\%$ annually. What would be the future value at age $60,(1)$ Employing the geometric equation, and $(2)$ Utilizing Microsoft Excel's built$-$in financial functions?