Please help q3 and q4, thank you!

nformation Sheet Project Overview: Throughout the semester, you will be working on an application based scenario on how to apply the course learning goals. All projects will be submitted through Excel. The "Info Sheet" (where you're now) will be the landing sage for all of the information to complete each Learning Goal Project. Make sure to keep up with the schedule for the due dates and review the rubrics to make sure you know how each Project will be graded. Let's get started! Your Role: Fast forward, and you have recently graduated from college, and you remember taking PFI 2301 and are super excited to se financially literate as you enter your first career-related job. However, your friend did not take PFI 2301 and is trying to igure what to do with their finances. They have contacted you for some guidance. Being the awesome friend you are, ou agree to walk them through the four personal finance elements (Basics, Borrowing, Building, \& Protecting) you earned in class! Scenario: Get started reviewing the information under "Unit 4: Protecting" to learn more about your riend, Jessica's financial situation. Q3 home and the coverage never increased, even though the policy required coverage of 80% of the replacement cost. Last month, he had a kitchen fire, which caused damages. How much will he have to pay out of pocket? \begin{tabular}{|l|l|} \hline Step 1: Calculate the Amount Loss minus the Deductible \\ \hline Step 2: Calculate the Replacement Cost \\ \hline Step 3: Calculate the \% Amount Covered \\ \hline Step 4: Calculate the Total Amount Reimbursed \\ \hline Step 5: What is the \% she will pay? (1 minus the \% amount covered) \\ \hline Step 6: What is the Total Amount she will pay? \\ \hline What observation do you see with this current coverage situation? What could be different? \\ \hline \\ \hline \end{tabular} Q4 Application Time! Jessica's heating/air-conditioning unit was struck by lightning. What is the actual cash value when it was struck by lightning? \begin{tabular}{|l|l|} \hline Step 1: What is the Purchase Price of the property? \\ \hline Step 2: Calculate: Current Age x (Price / Life Expectancy) \\ \hline Step 3: What is the Actual Cash Value? (Step 1 - Step 2) \\ \hline Based on the above information, why would it be important for Jessica and Sam to complete an inventory check of all of their personal property? \\ \hline \\ \hline \end{tabular} nformation Sheet Project Overview: Throughout the semester, you will be working on an application based scenario on how to apply the course learning goals. All projects will be submitted through Excel. The "Info Sheet" (where you're now) will be the landing sage for all of the information to complete each Learning Goal Project. Make sure to keep up with the schedule for the due dates and review the rubrics to make sure you know how each Project will be graded. Let's get started! Your Role: Fast forward, and you have recently graduated from college, and you remember taking PFI 2301 and are super excited to se financially literate as you enter your first career-related job. However, your friend did not take PFI 2301 and is trying to igure what to do with their finances. They have contacted you for some guidance. Being the awesome friend you are, ou agree to walk them through the four personal finance elements (Basics, Borrowing, Building, \& Protecting) you earned in class! Scenario: Get started reviewing the information under "Unit 4: Protecting" to learn more about your riend, Jessica's financial situation. Q3 home and the coverage never increased, even though the policy required coverage of 80% of the replacement cost. Last month, he had a kitchen fire, which caused damages. How much will he have to pay out of pocket? \begin{tabular}{|l|l|} \hline Step 1: Calculate the Amount Loss minus the Deductible \\ \hline Step 2: Calculate the Replacement Cost \\ \hline Step 3: Calculate the \% Amount Covered \\ \hline Step 4: Calculate the Total Amount Reimbursed \\ \hline Step 5: What is the \% she will pay? (1 minus the \% amount covered) \\ \hline Step 6: What is the Total Amount she will pay? \\ \hline What observation do you see with this current coverage situation? What could be different? \\ \hline \\ \hline \end{tabular} Q4 Application Time! Jessica's heating/air-conditioning unit was struck by lightning. What is the actual cash value when it was struck by lightning? \begin{tabular}{|l|l|} \hline Step 1: What is the Purchase Price of the property? \\ \hline Step 2: Calculate: Current Age x (Price / Life Expectancy) \\ \hline Step 3: What is the Actual Cash Value? (Step 1 - Step 2) \\ \hline Based on the above information, why would it be important for Jessica and Sam to complete an inventory check of all of their personal property? \\ \hline \\ \hline \end{tabular}