andMariaPopescu are hoping to purchase their firstapartmentand they are using Excel to helpmanage their family budget. The couple needs to estimate the monthly payments required for...

















and




Maria




Popescu are hoping to purchase their first




apartment


and they are using Excel to help




manage their family budget. The couple needs to estimate the monthly payments required for a




EUR




1


00


,000 mo


rtgage. They want to track their income and expenses using tables, charts, data bars, and




sparklines. Please help them







with the Excel part, not the money







.


The following elements are the




minimum required for building the excel file


: loan




amount


, annual




interest,




period


for the loan, family income per month, family expenses per month.


The file should be able to provide/calculate




at least the following elements


: total number of months




to repay, interest per month, monthly payment (by using PMT function), a


clustered column chart of




the income, expenses and net income for each month of the year, based on data of your choosing, a




what


-


if analysis by changing the length




of the loan





and




Maria




Popescu are hoping to purchase their first




apartment


and they are using Excel to help




manage their family budget. The couple needs to estimate the monthly payments required for a




EUR




1


00


,000 mo


rtgage. They want to track their income and expenses using tables, charts, data bars, and




sparklines. Please help them







with the Excel part, not the money







.


The following elements are the




minimum required for building the excel file


: loan




amount


, annual




interest,




period


for the loan, family income per month, family expenses per month.


The file should be able to provide/calculate




at least the following elements


: total number of months




to repay, interest per month, monthly payment (by using PMT function), a


clustered column chart of




the income, expenses and net income for each month of the year, based on data of your choosing, a




what


-


if analysis by changing the length




of the loanAndi




and




Maria




Popescu are hoping to purchase their first




apartment


and they are using Excel to help




manage their family budget. The couple needs to estimate the monthly payments required for a




EUR




1


00


,000 mo


rtgage. They want to track their income and expenses using tables, charts, data bars, and




sparklines. Please help them







with the Excel part, not the money







.


The following elements are the




minimum required for building the excel file


: loan




amount


, annual




interest,




period


for the loan, family income per month, family expenses per month.


The file should be able to provide/calculate




at least the following elements


: total number of months




to repay, interest per month, monthly payment (by using PMT function), a


clustered column chart of




the income, expenses and net income for each month of the year, based on data of your choosing, a




what


-


if analysis by changing the length




of the loan
Jan 08, 2023
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here