Question: Actions Calculate the missing entries. No Hard data should be used, just formulas and functions. Package Costs and Flight Cost s should be 'Looked' up
Actions | |||||
| Calculate the missing entries. No Hard data should be used, just formulas and functions. | |||||
| Package Costs and Flight Costs should be 'Looked' up from the entries in A18 through C22. Name this table 'Specials' | |||||
| If NO flight needed do not add one to Total Package cost [Hint: Use an IF statement] | |||||
| Balance should be calculated from Total Package cost minus Down Payment (20% of Package cost) | |||||
| Monthly payment calculated from Balance assuming one year to pay | |||||
| Total each column |
A39 X Date Prepared: Interest Rate: A B
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
