Reference no: EM13310108
1. On me car Lo.n Work Shoot Determine the month, payment, total payment, and interest interest is 4%.
2. Make suf. all cells in the loan calculation (From Sales Price to Interest Paid) are named by their
3. Using Scenario manager, create the current scenario and label it Pulaski. We are going to do various Interest rates.
4. Using the Scenario manager, create a new scenario labeled Bank of America with a 2.75% interest rate. 'For those that need a back story as to WHY we aren't using that rate as default, assume Bank of America needs lots more paperwork and takes longer (could be 2 months). You are working out if this extra work makes senSe.1
5 Create a Summary from the Scenario Manager, summarizing Monthly payments, total PaYments, and Interest paid.
6. Extra Credit: Copy the Car Loan tab and call it Goal Seek. On this tab, determine how mu. car can you afford (Sales Price, if you want to only make monthly payments of MO per month at
4% year, interest and 48 months, r ;
1. On the 2013 Sheet, make this a table. Use Table Style Light 10.
2. Remove Duplicates.
3. Insert 'Remaining Seats' as a column next to Seats Reserved. Calculate the remaining seats an equation for the entire column.
4. In the Air Included column, and ONLY for the actual data - not for the column itself, rnake s that the data is validated. The list of values allowed is Yes, No.
5. Add a total row. Find the total number of seats sold and the average price.
6. Determine the tours with a departure date > 6/1/2013 and with a price less than $2000. LE the tab like this. of Table
I. Go to the Pivot Table Tab. Create a pivot table on a new sheet, vvhere the Tours on the r the colurnns are by departure date
Seats reserved are in the values. We want the total number of seats reserved. Group the departure dates by month.
Create a bar chart by month for the Old Japan and Amazing Amazon Tour. Make the ch the it is easy to compare the two tours on any given month. (Hint: The two tours shot side by side on a given month.) Place the chart so that it is easy to read the pivot table
anri thp rhart takp, lin no more than 8 columns.
Attachment:- 322290_1_Excel-test.xlsx
|
Divine command theory is new theory-verbal acts
: Aquinas states that if ethics asserts that something is “good,” then there must be a final cause (goodness) toward which all things strive. Absolute good is a concept most aligned to virtue ethics and its proclivity to “perfectionism” Divine command ..
|
|
Calculate the rotational inertia of the wheel
: A forces of 16.88 N is applied tangentially to a wheel of radius 0.340 m and gives rise to an angular acceleration of 1.20 rad/s^2
|
|
Determine water pressure-pressure head and elevation head
: For each of the two cases below, determine the water pressure, pressure head, elevation head, and total head at points A, B, and C. Please solve the problem using: (a) the upper reservoir level as the datum
|
|
What is the height of the inclined plane
: A solid disk of radius 1.60 m and mass 2.3 kg rolls without slipping to the bottom of an inclined plane. what is the height of the inclined plane
|
|
Create a summary from the scenario manager
: Create a Summary from the Scenario Manager, summarizing Monthly payments, total PaYments, and Interest paid.
|
|
Define when would wells start interfering with each other
: One of the wells pumps at a rate of 1240 m3/ day and the second well pumps at 850 m3/ day. If the aquifer has a transmissivity of 2000 m2/ day and a storage coefficient of 4 x 10^-4, when would the wells start interfering with each other
|
|
Compute the new image distance
: An object is initially placed on the optical axis 21.2 cm to the left of a convex lens that has a focal length of 12.1 cm. what is the new image distance
|
|
Compitences for central bank of belize
: CASE STUDY ON COMPETENCIES For Central Bank of Belize
|
|
Determine how far from the film should the lens be placed
: A camera has a lens with a focal length of 22.2 cm. When an object is placed 3.55 meters away is being photographed
|