upload a file showing how too. The data is as follows:
- Was Unsure On How To Do This In Excel Didn T Know If Anyone Can Upload A File Showing How Too The Data Is As Follows 1 (140.23 KiB) Viewed 61 times
Was unsure on how to do this in excel, didn't know if anyone can upload a file showing how too. The data is as follows:
-
answerhappygod
- Site Admin
- Posts: 899604
- Joined: Mon Aug 02, 2021 8:13 am
Was unsure on how to do this in excel, didn't know if anyone can upload a file showing how too. The data is as follows:
Was unsure on how to do this in excel, didn't know if anyone can
upload a file showing how too. The data is as follows:
A B с D E F G H I J K L M N 0 P Q Q Instructions The purpose of this worksheet is to create a simulation of an investment in stocks and/or bonds over 10 years by applying what we learned in class (RANDBETWEEN, VLOOKUP, Absolute references, etc,) The stocks and bonds worksheet contains a table depicting an estimate of historic stock and bond gains or losses. Each cell represents a 10% chance ordered from worst to best annual return. * In order to use this data as a basis for a forecast: * Create a new worksheet called Investment Forecast Create a "menu" where the user can input their starting amount and percent to invest in stocks (create a data validation drop down box with values of .05 up to 1, formatted as percent) and percent to invest in bonds (set equal to 1 - stock pct) * Create a 10 year worksheet with the following columns: * Years (1 to 10) * Beginning of Year Balance (equals the starting amount in year 1, end of year balance in all other years) Beginning Stock Balance (equals beginning of year balance * stock percentage) * Stock Gains or Losses (Random stock return %) Ending Stock Balance (Beginning stock balance * (1 +stock gains or losses)) * Beginning Bond Balance (equals beginning of year balance * bond percentage) * Bond Gains or Losses (Random bond return %) Ending Bond Balance (Beginning bond balance * (1 + bond gains or losses)) * Ending of Year Balance (Ending Stock Balance + Ending Bond Balance) * Next to the menu, show a summary of the results: Final Balance, and Percent Earned (final balance-beginning balance) / beginning balance * Format all headings and data formats to look professional. All data should be centered, cells should be formatted appropriately (percentage or currency format rounded to whole dollars) *
upload a file showing how too. The data is as follows:
A B с D E F G H I J K L M N 0 P Q Q Instructions The purpose of this worksheet is to create a simulation of an investment in stocks and/or bonds over 10 years by applying what we learned in class (RANDBETWEEN, VLOOKUP, Absolute references, etc,) The stocks and bonds worksheet contains a table depicting an estimate of historic stock and bond gains or losses. Each cell represents a 10% chance ordered from worst to best annual return. * In order to use this data as a basis for a forecast: * Create a new worksheet called Investment Forecast Create a "menu" where the user can input their starting amount and percent to invest in stocks (create a data validation drop down box with values of .05 up to 1, formatted as percent) and percent to invest in bonds (set equal to 1 - stock pct) * Create a 10 year worksheet with the following columns: * Years (1 to 10) * Beginning of Year Balance (equals the starting amount in year 1, end of year balance in all other years) Beginning Stock Balance (equals beginning of year balance * stock percentage) * Stock Gains or Losses (Random stock return %) Ending Stock Balance (Beginning stock balance * (1 +stock gains or losses)) * Beginning Bond Balance (equals beginning of year balance * bond percentage) * Bond Gains or Losses (Random bond return %) Ending Bond Balance (Beginning bond balance * (1 + bond gains or losses)) * Ending of Year Balance (Ending Stock Balance + Ending Bond Balance) * Next to the menu, show a summary of the results: Final Balance, and Percent Earned (final balance-beginning balance) / beginning balance * Format all headings and data formats to look professional. All data should be centered, cells should be formatted appropriately (percentage or currency format rounded to whole dollars) *
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!